Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
pal25
Contributor III
Contributor III

How to apply chart specific filter ?

Hi

I have multiple  charts in a sheet. I want to apply some dimension based filter for each chart. For Chart 1 should always show Asia data, Chart should should always show Europe data and so on. 

Anyway this can be achieved ?

1 Solution

Accepted Solutions
MartW
Partner - Specialist
Partner - Specialist

Yes this is possible. you need some set analysis within you charts.

Set analysis looks like this:

Sum({<filterfield={'filter'}>} Measures field)

for you it can be something like this

Sum({<Country={'Japan'}>} Sales)

 

note: please only use set analysis in Measures. If you use them within dimensions you create a calculated dimension, it is best to avoid this.

 

see link to set analysis

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/ChartFunctions/Se... 

 

 

 

If this helped out, please like the post and accept this answer a the correct one

View solution in original post

2 Replies
MartW
Partner - Specialist
Partner - Specialist

Yes this is possible. you need some set analysis within you charts.

Set analysis looks like this:

Sum({<filterfield={'filter'}>} Measures field)

for you it can be something like this

Sum({<Country={'Japan'}>} Sales)

 

note: please only use set analysis in Measures. If you use them within dimensions you create a calculated dimension, it is best to avoid this.

 

see link to set analysis

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/ChartFunctions/Se... 

 

 

 

If this helped out, please like the post and accept this answer a the correct one

pal25
Contributor III
Contributor III
Author

@MartW  Thanks a lot