Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Conditional List Box?

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?

3 Replies
Highlighted
Specialist
Specialist

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.

Highlighted
Not applicable

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

Highlighted
MVP & Luminary
MVP & Luminary

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