topic Total Problem in Pivot table in QlikView

Total Problem in Pivot table

gizzel123 — Mon, 13 Jul 2015 07:33:44 GMT

Hi Guys,

I have a below PIVOT table.but my requirement is to get the total base on group as,

For each section,

a. Total for Today = sum of all lines identified as “today” in the group.

b. Total for Proposed = sum of all lines identified as “today” and “proposed” in the group.

c. Total for Future = sum of all lines identified as “today” and “proposed” and “future” in the group.

Is it possible? Please advise.

PrashantSangle — Mon, 13 Jul 2015 07:36:26 GMT

Hi,

Try

Sum(aggr(YourExpression,dim1,dim2))

Regards

gizzel123 — Mon, 13 Jul 2015 08:05:27 GMT

Dimension is the same, i,e GROUP.

it has 3 sections, today, proposed and Future.

I want to have total like: a) Total:today

b) Total:today+ proposed

c)Total:today+ proposed+ future

antoniotiman — Mon, 13 Jul 2015 08:09:43 GMT

Hi,

see attachment.

Regards,

Antonio

svenkita — Mon, 13 Jul 2015 08:41:27 GMT

Create a new expression

=RangeSum(Above(Total Sum(Cost),0,99))

This will give u a running total.

Hope this helps