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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Show list box value by Select Condition

Hi,

I have a question, i have two list box object.

the first one has two value (Select A, Select B), the second one has three value (A with flag Y, B with flag N, C with Flag Y)

When i choose Select A on the first list box, i want to show only A and C (value with Y flag) on the second list box. And when i choose Select B i want to show all values on the second list box.

I have try using this expression on the second list box -->

=if(GetFieldSelections(Selections)='Select A',

  Only({<Flag={'Y'}>}Value), Value

)

But it is not working and not showing any value.

Anybody has idea ?

i also attach my sample file here.

Thanks in advance.

12 Replies
Not applicable
Author

Hi Lejour,

Please check this.

definitely Working.

Anonymous
Not applicable
Author

I think that cant be done. Because in all d way. Select A is associated with A,C and Select B is associated with respective. So if you select or clear any one of them, the other will respond as per the association we have made in the expression.

qliksus
Specialist II
Specialist II

Hi ,

This is kind of indirect method just check and let me know if this works