Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. 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

2 Replies
antoniotiman
Honored Contributor III

Re: Values automalically selected on selection

Hi Youssef,

see attachment.

I have used triggers in fields.

Regards,

Antonio

YoussefBelloum
Esteemed Contributor

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)