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: 
Not applicable

Group multiple values into one in chart

Hi everyone,

I have a stacked bar chart displaying the biggest 20 values in a field. I would like to group some of the displayed values to display as one value with a new name, and ideally let the user be able to switch back and forth between the two views. Is this possible somehow? Perhaps by making a variable?

1 Solution

Accepted Solutions
Marcio_Campestrini
Specialist
Specialist

Hi Andrew

You can load an inline table and joining it to the table where you have the values. After this, you create a cyclical dimension and apply it to your chart. In this way, you can resume the field and you provide the user a way to change the chart view.

Márcio

Márcio Rodrigo Campestrini

View solution in original post

2 Replies
Marcio_Campestrini
Specialist
Specialist

Hi Andrew

You can load an inline table and joining it to the table where you have the values. After this, you create a cyclical dimension and apply it to your chart. In this way, you can resume the field and you provide the user a way to change the chart view.

Márcio

Márcio Rodrigo Campestrini
Not applicable
Author

Thanks Marcio. Haven't had a chance to get to this one, but it seems correct