Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

2 Alternate states on One listbox?

Hi Friends,

I have 2 listboxes: Study and Site.

I want only those sites to be shown under the selected study.

So i added the following expression to the site listbox :

aggr(only({<site_num= P(site_num)>}site_num),site_num)

It worked.

But 3 charts have to shown at study level and 5 on site level. So i created a 'study' alter nate state for the 3 charts and the study listbox. but now the site listbox is not getting affected by study listbox, as it is under inherited state(and so are the other 5 charts).

Can there be an expression for site listbox where it only picks up value of selected study from study loistbox, and not be a part of study alternate state?.

Thanks in advance.

0 Replies