Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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