Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
absolutconsulting
New Contributor

Grouping values under same concept

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

AB
1100
2230
3330
4250
5452
6452
7262
8151
9393

 

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

1 Reply
Partner
Partner

Re: Grouping values under same concept

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:

01.PNG

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

02.PNG

I hope this is what you are looking for.

 

Regards,

Mark Costa