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?
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: