Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

amit_saini
Honored Contributor III

Filter Legends help

Hi Folks,

I'm having below Line chart , what I'm looking for is any easy way of doing filtering on Legends:

Suppose I just want to filter for Legends : SP_Time_PinchLine_L_1_Max and SP_Time_PinchLine_L_1_MIN , just to compare these two.

Any suggestions how this can be possible!

I tried just selecting my mouse these 2 , but it's not working.

I'm thinking of creating list box with these legends on right side of above chart, so that users can select anyone to compare, but no sure if this is possible as all these are $Field.

Here my Dim = Date

Expressions are :

Exp1 :AV_Tmp_PinchLine_L_1

Exp2 Smiley FrustratedP_Tmp_PinchLine_L_1_MAX

Exp3 Smiley FrustratedP_Tmp_PinchLine_L_1_MIN

Exp4 :AV_Tmp_PinchLine_L_2

...

..

and so on

Thanks,

AS

1 Solution

Accepted Solutions
prat1507
Valued Contributor

Re: Filter Legends help

Hi AS

Create an inline where you have something like this

Tab;

Load * Inline [

Dim

AV_Tmp_PinchLine_L_1

SP_Tmp_PinchLine_L_1_MAX

SP_Tmp_PinchLine_L_1_MIN

AV_Tmp_PinchLine_L_2

];

so you can have a listbox where you can choose which line charts to show up.

Now create a listbox with Dim as your field

and then go into your line chart, where you'll have Conditional option for each expression

Type this for your first expression:

GetSelectedCount(Dim)=0 or substringcount(GetFieldSelections(Dim),'AV_Tmp_PinchLine_L_1')>0


and so on for all the expressions and you're good to play with the chart.


Regards
Pratyush

1 Reply
prat1507
Valued Contributor

Re: Filter Legends help

Hi AS

Create an inline where you have something like this

Tab;

Load * Inline [

Dim

AV_Tmp_PinchLine_L_1

SP_Tmp_PinchLine_L_1_MAX

SP_Tmp_PinchLine_L_1_MIN

AV_Tmp_PinchLine_L_2

];

so you can have a listbox where you can choose which line charts to show up.

Now create a listbox with Dim as your field

and then go into your line chart, where you'll have Conditional option for each expression

Type this for your first expression:

GetSelectedCount(Dim)=0 or substringcount(GetFieldSelections(Dim),'AV_Tmp_PinchLine_L_1')>0


and so on for all the expressions and you're good to play with the chart.


Regards
Pratyush

Community Browser