Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
buzzy996
Master II
Master II

DropDown selection issue

hi pals,

i have two list boxes, 1for changing x-axis and 2nd one for choosing selection varaibale(Sel Val drop down list)...

If vXAxis=Zone--->need to display only these things(

'East

                 West

                 North

                 South

) in 2nd list box(Sel Val)

if vXAxis=AgentName-------->need to display only these things(Anotny;

                     Brad;

                     Cloney;

                     Cook;

                     Ethan;

                     George;

                     Grant;

                     Hughes;

                     Hunt;

                     John;

                     Mark;

                     Newmen;

                     Paul;

                     Roberts;

                     Robin;

                     Tim)in 2nd list box(Sel Val)

how we can do it in QlikView application?pls let me know any one!!!

thanking u...

1 Reply
jagan
Luminary Alumni
Luminary Alumni

Hi,

Create an Inline table with the following columns

Type          Value

Zone              East

Zone               West

Zone               North

Zone               South

AgentName     Brad

AgentName     Cloney

'                      Cook

'                     Ethan

'                     George

'                     Grant

'                     Hughes

'                     Hunt

'                     John

'                     Mark

'                     Newmen

'                     Paul

'                     Roberts

'                     Robin

'                     Tim

Like this create an inline/Excel/CSV file.

Now use the two fiels as filters, as they have association between them when you select zone it will enable only those who has zone.

Hope this helps you.

Regards,

Jagan.