topic Re: Conditional List Box? in QlikView

Conditional List Box?

Mon, 19 Jan 2015 19:16:39 GMT

I have a list box that allows selection of campaigns on several tabs. Each tab will only contain data from certain campaigns but the list box shows all possible values (not specific to the tab). Is there a way to make the list box contain campaigns only applicable to the tab I am on?

Re: Conditional List Box?

Anonymous — Mon, 19 Jan 2015 19:24:33 GMT

you need to set a flag if there isn't already a way/logic to how the campaigns are assigned to a specific tab. then you can use set analysis to show only the specific campaigns on each tab. post a sample data set if possible, and we can help you come up with the exact expressions.

Re: Conditional List Box?

Mon, 19 Jan 2015 20:09:15 GMT

You can mention the condition to display only particular campaign in the list box using expression in listbox ("General" tab -> Field dropdown -> Expression)

Re: Conditional List Box?

rwunderlich — Mon, 19 Jan 2015 20:51:08 GMT

One way to filter dimensions in a list box is with aggr() like this:

=aggr(only({<Type={email}>}Campaign), Campaign)

Where "Type={email}" is some sort of filtering condition(s).

-Rob

http://masterssummit.com

http://robwunderlich.com