Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

I have the following requirement. I need to set the contents of a LIST BOX based on the selection from another LIST BOX

I have the following requirement. I need to set the contentsof a LIST BOX based on the selection from another LIST BOX.

LIST BOX1  values Canada, USA /    LIST BOX2 values    Ontario, Quebec,  New York , Ohio

So when the LIST BOX1 has Canada selected, then LIST BOX2 should only display Ontario and Quebec and when
LIST BOX1 has USA selected the LIST BOX2 should only allow New York and Ohio.

Suggestions….

3 Replies
alexandros17
Partner
Partner

This is an automatic behaviour when data is properly linked, there must be a relationship between Canada and its regions, otherwise you must build this link on your own.

jvishnuram
Partner
Partner

Hi Marcus,

Try this out.,

SAMPLE:

LOAD * INLINE [

    Region, Country

    Canada, Ontario

    USA, Ohio

    USA, New York

    Canada, Quebec

];


if you are able to see my app, PFA.,

MK_QSL
MVP
MVP

Just create the list box Country using below expression

=Aggr(Country,Country)