topic Multiple list boxes using same field in QlikView

Multiple list boxes using same field

phcaptjim — Wed, 23 Oct 2013 15:21:21 GMT

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).

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!

Re: Multiple list boxes using same field

marcus_malinow — Wed, 23 Oct 2013 15:29:52 GMT

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.

Re: Multiple list boxes using same field

preminqlik — Wed, 23 Oct 2013 16:38:09 GMT

GO THROUGH ''WHATS NEW IN QLIKVIEW 11'' REPORTS TAB ...YOU CAN COME TO KNOW THAT EXACTLY...

Re: Multiple list boxes using same field

tresB — Wed, 23 Oct 2013 17:21:27 GMT

I guess, you need alternate state (QV11).