Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
Tags (1)
1 Solution

Accepted Solutions

Re: Dynamic Filter issue

See attached qvw.


talk is cheap, supply exceeds demand
3 Replies
mov
Esteemed Contributor III

Re: Dynamic Filter issue

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

Re: Dynamic Filter issue

See attached qvw.


talk is cheap, supply exceeds demand
Not applicable

Re: Dynamic Filter issue

Thanks Gysbert ...It worked...

Community Browser