Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

YoussefBelloum
Not applicable

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

2 Replies
antoniotiman
Not applicable

Re: Values automalically selected on selection

Hi Youssef,

see attachment.

I have used triggers in fields.

Regards,

Antonio

YoussefBelloum
Not applicable

Re: Values automalically selected on selection

Hi Antonio,

thank you, but that isn't what i'm looking for.

stalwar1‌ just give me the right answer:

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