Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
MVP
MVP

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..

MVP
MVP

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 !

Community Browser