topic 2 Alternate states on One listbox? in QlikView https://community.qlik.com/t5/QlikView/2-Alternate-states-on-One-listbox/m-p/1292305#M403869 <HTML><HEAD></HEAD><BODY><P>Hi Friends,</P><P></P><P></P><P>I have 2 listboxes: Study and Site.</P><P>I want only those sites to be shown under the selected study. </P><P>So i added the following expression to the site listbox :</P><P>aggr(only({&lt;site_num= P(site_num)&gt;}site_num),site_num)</P><P>It worked.</P><P>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).</P><P>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?.</P><P></P><P>Thanks in advance.</P></BODY></HTML> Sun, 22 Jan 2017 14:34:04 GMT 2017-01-22T14:34:04Z 2 Alternate states on One listbox? https://community.qlik.com/t5/QlikView/2-Alternate-states-on-One-listbox/m-p/1292305#M403869 <HTML><HEAD></HEAD><BODY><P>Hi Friends,</P><P></P><P></P><P>I have 2 listboxes: Study and Site.</P><P>I want only those sites to be shown under the selected study. </P><P>So i added the following expression to the site listbox :</P><P>aggr(only({&lt;site_num= P(site_num)&gt;}site_num),site_num)</P><P>It worked.</P><P>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).</P><P>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?.</P><P></P><P>Thanks in advance.</P></BODY></HTML> Sun, 22 Jan 2017 14:34:04 GMT https://community.qlik.com/t5/QlikView/2-Alternate-states-on-One-listbox/m-p/1292305#M403869 2017-01-22T14:34:04Z