topic Re: Grouping Values within a Dimension in Chart in QlikView

Grouping Values within a Dimension in Chart

Thu, 23 May 2013 06:41:00 GMT

One of the dimensions in my chart contains many values. I want to show the chart with a few of those grouped together. As shown in the attached file there are two descriptions which I want to group together only for the purpose of this chart and not at script level.

Is there any quick way of doing this?

Thanks.

Re: Grouping Values within a Dimension in Chart

Thu, 23 May 2013 06:47:26 GMT

The best way to do is create a new field on a table to group values like this.

Load a,

if(a='value','grouped value',if(a='value 2','grouped value',a)) as group

form ....

i Hope to help you.

Re: Grouping Values within a Dimension in Chart

Sokkorn — Thu, 23 May 2013 06:47:27 GMT

Hi,

Maybe use <Add Calculated Diemension> can do this job. Let try =If(WildMatch(DIS_DESC,'*NORMAL DELIVERY*','*BY C-SECTION*','GroupName',DIS_DESC))

Regards,

Sokkorn