topic Re: How to 'Group By' a Dimension values in Straight Table? in QlikView

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

abc_18 — Wed, 16 Nov 2022 07:23:12 GMT

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.

Please suggest how can I achieve this.

Mark_Little — Wed, 16 Nov 2022 07:37:41 GMT

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

abc_18 — Wed, 16 Nov 2022 08:47:18 GMT

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.