Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dynamic Filter issue

What I'm trying to do is create a dynamic filter2 where filter1 is created as Type ={A,B,C} as values using inline table...


Suppose if I select Type as A.....Only {A,B,C} possible values should be available in next filter(Currently im seeing all values)

Ex1: Filter1 ....A

        Filter2 ....{A,B,C}


Ex2: Filter1 ....B

     Filter2 ....{1,2,3}


Please suggest...Expression used for Filter 2

Filter2 =if(Type ='A',[Column A],if(Type= 'B',,[Column B],[Column C]))


Data is shown below

Column AColumn BColumn C
A1Y
A2Y
A3Y
A4Y
A5N
A6N
B1Y
B2Y
B3Y
B4Y
B5N
B6N
C1Y
C2Y
C3Y
C4Y
C5N
C6N
1 Solution

Accepted Solutions
Gysbert_Wassenaar

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Anonymous
Not applicable
Author

Not quite clear...  Hope I got it close enough to be helpful - see attached.

Gysbert_Wassenaar

See attached qvw.


talk is cheap, supply exceeds demand
Not applicable
Author

Thanks Gysbert ...It worked...