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: 
bhavvibudagam
Creator II
Creator II

How to filter the chart by Measure

Hi Experts,

Can any one please help me on below requirement.

I have a line chart with total 13 measures.with one dimension.

Is there any way to filter the chart by Measure. For example in the below chart there are three measures.

By default chart has to show all these three measures and user able to filter any one measure like New visitor then it has to show month wise New visitors.

Please help me on this.

Please find the below attached sample test app.

sample chart.png

Thanks in advance.

1 Solution

Accepted Solutions
7 Replies
sunny_talwar

Can you repost the app back after adding the below table

Dim:

LOAD * INLINE [

Dim

1

2

3

];

bhavvibudagam
Creator II
Creator II
Author

Hi Sunny,

Thanks for your reply.

Please find the below attached app with inline script and source file.

Here by default chart has to show all the three measures.

In a filter pane need to show all the measure user may select 2 measures also at a time then 2 trends need to show on chart. Please help me on this requirement.

sunny_talwar

Check this out

Capture.PNG

bhavvibudagam
Creator II
Creator II
Author

Hi Sunny,

Thanks a lot for great solution. When I have filtered one measure in the legend, in the selection bar its showing Pick(). I have given label as Measure under dimension section  but still showing pick() is it possible give label here to hide the formula.

Thanks in advance.

test1.png

avinashelite

No its a bug in Qliksense ..even if you define the label for calculated DIM it won't reflect

joep_026
Contributor III
Contributor III

Hello Mister Talwar,

Just now I have been looking for the same solution.

Is it possible for you to show the formula you created and how?

I'm looking forward hearing from you!

Kind regards,

Joep Schiffelers

guidocobs
Contributor
Contributor

Hello,

I would adopt this solution, but using 4 measures I am calculating within another chart.

Is that possible?

 

Thanks for the answers

Guido