Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
CasperQlik
Creator
Creator

User selections with set analysis

Hi Qlik Community

I have a stacked bar chart with a fairly simple measure like this:

sum({< category = {"cat1", "cat2", "cat3"} >} values)

This produces a stacked bar chart as desired.

But the users cannot select individual categories now. Not from a filter object or directly in the chart. If they try and select a category from the chart they just select the entire column of stacked values and not the individual category.

Is this functionality possible?

 

Any help is appreciated!

/Casper

1 Solution

Accepted Solutions
Or
MVP
MVP

In this example, the chart will always display the same three categories regardless of selection because that's what it's coded to do.

If you want them to be able to select additional categories that will be added to those three, you can use:

sum({< category += {"cat1", "cat2", "cat3"} >} values)

If you want them to be able to select one or two of these three categories and only have those displayed, you can use:

sum({< category *= {"cat1", "cat2", "cat3"} >} values)

 

View solution in original post

2 Replies
Or
MVP
MVP

In this example, the chart will always display the same three categories regardless of selection because that's what it's coded to do.

If you want them to be able to select additional categories that will be added to those three, you can use:

sum({< category += {"cat1", "cat2", "cat3"} >} values)

If you want them to be able to select one or two of these three categories and only have those displayed, you can use:

sum({< category *= {"cat1", "cat2", "cat3"} >} values)

 

CasperQlik
Creator
Creator
Author

Thank you!

This was the exact solution I was looking for. Specifically the second solution with the '*='.