Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
abc_18
Creator II
Creator II

How to 'Group By' a Dimension values in Straight Table?

I have a straight table like below created in Qlikview.

requirement is to group the values in this table, Only "p-2" and "p-3 & below (p-4, p-5, p-6..)" should be populated on this table.

For "p-3 & below" row, this will show the aggregate of "p-3" and lower values only.

Number - update p Total
20.0.15344-No update p-6 4
20.0.16554-Update on Oct p-4 5
20.0.17456-Update on Dec p-3 12
20.0.17457-Update on May p-2 234
20.0.18657-Update on May p-1 125
10.0.18658-Update on Sept p 78
5.1.4567-June update   90

Please suggest how can I achieve this.

Labels (2)
2 Replies
Mark_Little
Luminary
Luminary

Hi @abc_18 

I would create the Aggr field in the script with an if statement. Then you can use that instead.

 

abc_18
Creator II
Creator II
Author

Hi Mark,

Can you please elaborate more on this?

These fields are directly coming from a table with the values like 

Load*,

Number

update 

P from XYZ;

P having values as (p-1, p+, p+2, p+3,p-2, p-3, p-4, p-5, p-6....)

Number column having values as 20.0.17456-, .... and Update column having values similar to Update on May like these...

and Total I am calculating at expression level.

How to write aggr for this, tried using it in from end at chart level but it didn't work.