Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
YoussefBelloum
Esteemed Contributor

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

Re: Values automalically selected on selection

Check attached

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

5 Replies
psilva001
Contributor

Re: Values automalically selected on selection

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

YoussefBelloum
Esteemed Contributor

Re: Values automalically selected on selection

Hi Päulo,

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

YoussefBelloum
Esteemed Contributor

Re: Values automalically selected on selection

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

Re: Values automalically selected on selection

Check attached

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

YoussefBelloum
Esteemed Contributor

Re: Values automalically selected on selection

Thank you so much !