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: 
mukesh19
Contributor II
Contributor II

Dynamic reference lines for bar chart based only on the filter pane

Hi all,

I have a bar chart, table and filterpane. I want to add the reference line for the bar chart in such a way that the reference line should be based on the filterpane, if no selection is done the reference line should show the complete value, If selection is done it should show only value related to that selection.  The important criteria is reference should not change  based on the other selections except the filterpane.

thanks,

mukesh

1 Solution

Accepted Solutions
agigliotti
Partner - Champion
Partner - Champion

in your measure expression you should use a set analysis to ignore all selections except for the subject field.

ex. sum( {1< subject = $::subject >} your_measure_field )

View solution in original post

16 Replies
agigliotti
Partner - Champion
Partner - Champion

what fields do you have on your filterpane ?

mukesh19
Contributor II
Contributor II
Author

subject

agigliotti
Partner - Champion
Partner - Champion

in your measure expression you should use a set analysis to ignore all selections except for the subject field.

ex. sum( {1< subject = $::subject >} your_measure_field )

mohan_1105
Partner - Creator III
Partner - Creator III

A slight Modification of Andrea expression,

sum({<subject=>} your_measure_field)


This Expression also work ...!!

mukesh19
Contributor II
Contributor II
Author

The value has to be overall value instead of any selection

mohan_1105
Partner - Creator III
Partner - Creator III

That any selection includes "Subject"?

mukesh19
Contributor II
Contributor II
Author

for eg.:  I have many filterpanes subject,x,y,so on...There is a bar chart with reference line. The reference lines should change the values only with respective to the selection in subject only, not with the other x,y,z so onn fileds.

agigliotti
Partner - Champion
Partner - Champion

did you try the expression i suggested you?

mukesh19
Contributor II
Contributor II
Author

yes i tried but its not wrkng