Discussion Board for collaboration related to QlikView App Development.
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 whenLIST BOX1 has USA selected the LIST BOX2 should only allow New York and Ohio.
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.
Try this out.,
LOAD * INLINE [
USA, New York
if you are able to see my app, PFA.,
Just create the list box Country using below expression