Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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?

Tags (3)
3 Replies
Highlighted
Specialist
Specialist

Re: Conditional List Box?

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

Re: Conditional List Box?

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

Re: Conditional List Box?

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