Skip to main content
Announcements
Happy New Year! Cheers to another year of collaboration, connections and success.
cancel
Showing results for 
Search instead for 
Did you mean: 
Akash2k
Contributor III
Contributor III

Filter on a particular chart only

How to create a filter which applies only to a particular Bar chart but not to other charts

Labels (3)
1 Solution

Accepted Solutions
Kushal_Chawda

@Akash2k  Try below

1) Add filter to alternate state.

2) Create measure in bar chart with alternate state intersection with other filter as below

This way your filter will only work for bar chart as filter is in alternate state and it is referred only in bar chart measure, so other visualisation will not be affected. Also bar chart will take other selections in account as defined in bar chart measure

Sum({[Compare 1]*$}Value) -- where [Compare 1] is defined alternate state

View solution in original post

6 Replies
Akash2k
Contributor III
Contributor III
Author

If I create and use that alternate state, the filter only works on the bar chart( other filters are not working on this bar chart).

However, I expect this filter to work specifically on the bar chart, while also allowing other filters to apply to it as well

thanks for your help

Qrishna
Master
Master

Apply the alternates states to the filter and not the bar chart.

In the bar chart expression, Try writing an if statement, whn getselectedcount(Altstates_yourfilter) > 0, then Measure1 else Measure2. Measure1 has the expression with alternatestates included. if that doesnt work, check on how to write an expression to include current selections and alternate states. 

https://help.qlik.com/en-US/qlikview/May2024/Subsystems/Client/Content/QV_QlikView/Examples%20of%20A...

Kushal_Chawda

@Akash2k  Try below

1) Add filter to alternate state.

2) Create measure in bar chart with alternate state intersection with other filter as below

This way your filter will only work for bar chart as filter is in alternate state and it is referred only in bar chart measure, so other visualisation will not be affected. Also bar chart will take other selections in account as defined in bar chart measure

Sum({[Compare 1]*$}Value) -- where [Compare 1] is defined alternate state

Akash2k
Contributor III
Contributor III
Author

Great that works ,

Thank you so much kushal ,Qrishna, anat

Akash2k
Contributor III
Contributor III
Author

How can i apply the same in a table chart

where there is no measure column