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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Sebastian_Dec
Creator II
Creator II

Parent filter in chart by one measure

Hi, I need to make bar charts with group(measure)/shops(dimension-stack)/sell(dimension-bar).

I have 5 groupings and I need to make 5 charts, each for a different group. Unfortunately the groups are stacked together and I can make one graph and then have the user filter, but that's not the point.

There must be 5 plots, each for a different group (Group A, B, C....), and I can't separate the group by Data Load Editor.

So how to make a permanent filter on a chart without using Data Load Editor and Alternate States?

I need some expresion in measure but what i try dont work.

 

Thanks & Regards,
Please close the thread by marking correct answer & give likes if you like the post.
1 Solution

Accepted Solutions
neerajthakur
Creator III
Creator III

Use this in your measure for each chart in set expression Sum({<Group={'Group1'}>} Sales)

This way you will have 5 different charts 1 for each Group.

Thanks & Regards,
Please Accepts as Solution if it solves your query.

View solution in original post

2 Replies
neerajthakur
Creator III
Creator III

Use this in your measure for each chart in set expression Sum({<Group={'Group1'}>} Sales)

This way you will have 5 different charts 1 for each Group.

Thanks & Regards,
Please Accepts as Solution if it solves your query.
Sebastian_Dec
Creator II
Creator II
Author

Thx for help.

I use this code and works.

PS: also this code work in the dimenstion-bar:
=if(wildmatch(Group,'Group1'),Group)

Thanks & Regards,
Please close the thread by marking correct answer & give likes if you like the post.