topic Re: Group multiple values into one in chart in QlikView

Group multiple values into one in chart

Tue, 28 Oct 2014 15:30:07 GMT

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?

Re: Group multiple values into one in chart

Marcio_Campestrini — Tue, 28 Oct 2014 15:36:00 GMT

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

Re: Group multiple values into one in chart

Wed, 29 Oct 2014 21:43:27 GMT

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