Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

How to get specific values from other list selection instead of displaying all values

I am using multiple list boxes and loading all the values from using select statement.

My requirement is, i want to list only based on my selection and not all the data.

For example,

Initially i am loading all the data in multiple list boxes.

If i select First list box, then the second list box data should be based on my first list box selection.

If i select First second box, then the third list box data should be based on my second list box selection.

How to do this..?

 

Labels (2)
1 Solution

Accepted Solutions
Highlighted

PFA

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

3 Replies
Highlighted

PFA

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

Highlighted
Creator
Creator

Thanks. it is great help.
I have below issue.
In the first approach, when i select first list box (field1 listbox) which is the value "A" then it will display only A1,A2 ==> This is correct.
But, when i select value "B", then it will display A1,A2,B1,B2 ==> It should display B1,B2 only. it should not display A1,A2 ..
I don't want to display other mapping values.
how to do this...

Note : i have added some more records in the attached file.

Also, Search is not working when i apply expression.

Highlighted

Two functionality working here. PFA

Because of not selecting, Data holding duplicates.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)