Grouping values under same concept

absolutconsulting — Sun, 10 Feb 2019 11:35:49 GMT

Hi guys,

I have the following problem,

I would like to make a chart grouping some values under the same concept. the first possibility is to add a column to the excel file and group then and then load it, but i would like to do it in Qlikview

Example:

The table look like this

A	B
1	100
2	230
3	330
4	250
5	452
6	452
7	262
8	151
9	393

I want to make 3,4 and 9 together. Can someone help me?

Re: Grouping values under same concept

marksouzacosta — Mon, 11 Feb 2019 04:11:46 GMT

Hi,

I have added an extra column called Group during the Load Script that groups the values 3, 4 and 9 - this will have the same effect as you adding a column in the Excel so I don't know if this is what you are looking for:

[MappingGroups]:
MAPPING LOAD * INLINE [
  ID,GROUP
  3,3
  4,3
  9,3
];


[DataSource]:
LOAD
  A,
  ApplyMap('MappingGroups',A,A) AS Group,
  B
;
LOAD * INLINE [
  A,B
  1,100
  2,230
  3,330
  4,250
  5,452
  6,452
  7,262
  8,151
  9,393
];

This Load Script will generate the following table:

And you can create charts like those below - the Measure expressions are in the header of the charts:

I hope this is what you are looking for.

Regards,

Mark Costa

topic Grouping values under same concept in QlikView

Grouping values under same concept

Re: Grouping values under same concept