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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
YoussefBelloum
Champion
Champion

Values automalically selected on selection

Hi Guys,

Im stuck and i need you help.

I have two tables, the first one include one Field "A" and the second one include one Field "B"

when i select the value aa on the Field A, i want the listbox of the Field B to show only the value yy.. and until there it works.

But when i select the value yy on the second listbox, i have all the values of the first listbox selected automatically, which is a problem for me..

You can find attached the app

Thanks!

YB

1 Solution

Accepted Solutions
sunny_talwar

Check attached

=if(GetFieldSelections(A)='aa', Aggr(Only({<B = {'yy'}>} B), B), B)

View solution in original post

5 Replies
Anonymous
Not applicable

you must withdraw the comma after 'A', at the line 14.

YoussefBelloum
Champion
Champion
Author

Hi Päulo,

I didn't pay attention on that. but it didn't resolve the problem..

YoussefBelloum
Champion
Champion
Author

stalwar1‌ since a can't send you a message..

sunny_talwar

Check attached

=if(GetFieldSelections(A)='aa', Aggr(Only({<B = {'yy'}>} B), B), B)

YoussefBelloum
Champion
Champion
Author

Thank you so much !