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: 
absolutconsulting
Contributor
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
marksouzacosta

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

Read more at Data Voyagers - datavoyagers.net
Follow me on my LinkedIn | Know IPC Global at ipc-global.com