topic Re: Partial vertical sum in pivot table in QlikView

Partial vertical sum in pivot table

alex59800 — Tue, 12 Jul 2016 16:24:59 GMT

Hello all,

I try to set a partial sum in a pivot table.

Tow dimensions, markets and delay.

My wish is to make a sum of amount considered out of delay (0-30 days until +360 days), from the rest of the dimension (in time).

The actual pivot at the top of the excel attached and what i am looking to achieve just below.

Thanks a lot for your help

PS: i tried

=if(columnNo()=4 ,RangeSum(before(Sum(montanttest),0, ColumnNo(TOTAL)))) bit i have still column with null value inside i can not get ride of....may be something to do with set analysis do not know

Re: Partial vertical sum in pivot table

sunny_talwar — Tue, 12 Jul 2016 16:40:35 GMT

Is delay a calculated dimension or a field which is getting calculated in the script?

Re: Partial vertical sum in pivot table

marcus_sommer — Tue, 12 Jul 2016 17:03:21 GMT

I think you need to create your "Total not in time" as an additionally field-value for the field delay (maybe you create an extra dimension for this) and then your expression would be like:

if(delay = 'Total not in time', sum(total <Markets> montanttest), sum(montanttest))

- Marcus

Re: Partial vertical sum in pivot table

alex59800 — Wed, 13 Jul 2016 07:02:56 GMT

Hello Sunny it's an inline function in the srcipt depending (today - due date).