Can a combo box be mapped to cells containing vlookup formulae?
These vlookups lookup values in a range of cells which dynamically change according to each selection triggering a Query connection.
When I take a snapshot of this dashboard in preview mode, I can see values in those cells mapped. But in run time, they don’t show up. (So there is nothing wrong with the logic and connections.) Its the Display layer that is giving me this issue.
I have been having nightmares from a while on this trying to figure out a fix.
The issue seems to be with the presentation / Display layer. When I map the area where the values get updated, it does not display values; but when I take a snapshot of this in the preview mode, those same cells are populated. I find out that this is the issue with Vlookups not getting updated dynamically on the presentation layer while they update fine in the background at excel level.
But again, I found a work around for this for now - I am getting the duplicate values as it is from the query and for the Combo box Insertion type property, instead of ROWS, I am using FILTERED ROWS which takes off the duplicates. I just did not know this feature was added in this Dashboard Design 4.0 SP4 Patch 5 update. GREAT HELP it is. Thanks Debbie for responding.
(BOB member since 2005-03-01)