Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
mark_costa
Contributor

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

Community Browser