Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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.