Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've got a question about using the same field across multiple list boxes. I'm not even sure if this will work like I want it to, but there has to be a fairly simple solution to this task.
I have a table of metrics (MM) and that joins out to a fact table (FACTS) on (METRIC_NAME).
MM
METRIC_NAME
METRIC_GROUP
FACTS
DATE
METRIC_NAME
NUMERATOR
DENOMINATOR
DEPARTMENT
I have a separate list box setup for each metric group (there are 7 groups). I also have a pivot table setup with departments going on each row and each metric name going into a column as a dimension. I want the user to be able to select which metrics are displayed. This works well with one list box for all the metrics, not so good for separate list boxes.
What is the easiest way to do this? I could do a separate metric table that is not linked to the main tables, but not sure how to relate that back to the pivot table correctly.
Any help would be great! Thanks!
If you've got QlikView 11 you should be able to use 'Enable Conditional' on your dimensions, or 'Conditional' on your Expressions.
Then, for example, if your Dimension is called Region, load a record into a data island with a field called perhaps '_dimension' and a value of Region
In the condition for the display of that dimension, put this:
SubStringCount(Concat(_dimension, '|'), 'Region')
(note that I shamelessly ripped this out of the 'What's new in QlikView 11' document, which you can find by searching this site.
GO THROUGH ''WHATS NEW IN QLIKVIEW 11'' REPORTS TAB ...YOU CAN COME TO KNOW THAT EXACTLY...
I guess, you need alternate state (QV11).