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: 
amit_saini
Master III
Master 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 :SP_Tmp_PinchLine_L_1_MAX

Exp3 :SP_Tmp_PinchLine_L_1_MIN

Exp4 :AV_Tmp_PinchLine_L_2

...

..

and so on

Thanks,

AS

1 Solution

Accepted Solutions
prat1507
Specialist
Specialist

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

View solution in original post

1 Reply
prat1507
Specialist
Specialist

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