Cumulative Dimension

[nacera_abbas]

Hello,

I'm facing an issue about rangesum function in a Pivot table,

I calculate a cumulative amount like this

The expression:

if((Dimensionality())=1,

rangesum( sum(  aggr(   rangesum(   above(  Sum( {$<expr>} Amount)  ,0,rowno(TOTAL)  )  )  , Dimension 1  )  )

, sum (Amount)

I have 2 dimensions:

Dimension1 diplayed in rows and Dimension2 displayed in Columns.

This is how we want to display the pivot table:

Dimension1	Dimension3	Dimension4	Dimension2	Z1	Z2	Total
A	A1			10	20	30
A	A2	A21		1	3	4
A	A2	A22		1	2	3
A	A2	A23		2	4	6
A	A2	A24		1	5	6
A	A2	Total		4	14	18
A	Total			14	34	48
B	B1			2	3	5
B	Total			16	37	53
C				17	38	55
D				18	39	57
E				19	40	59
F	F1			1	2	3
G	Total			20	42	62
Total				20	42	62

And for the moment I have this:

Dimension1	Dimension3	Dimension4	Dimension2	Z1	Z2	Total
A	A1			10	20	30
A	A2	A21		1	3	4
A	A2	A22		1	2	3
A	A2	A23		2	4	6
A	A2	A24		1	5	6
A	A2	Total		4	14	18
A	Total			34	0	34
B	B1			2	3	5
B	Total			53	0	53
C				55	0	55
D				57	0	57
E				59	0	59
F	F1			3	0	3
G	Total			62	0	62
Total				62	0	62

Does anyone has any idea on how I could fix this issue?

Many thanks,

Nacera

Ce message a été modifié par : nacera abbas

[nacera_abbas]

Hi stalwar1‌,

Is there any way to handle the null value in the expression?

Many thanks,

[sunny_talwar]

Which null? The one I mentioned above in my post?

[nacera_abbas]

Yes, those ones.

I tried to add fictif rows with zeros but I can't imagine all cases to do that

[sunny_talwar]

Best way is to generate missing data in the script

Generating Missing Data In QlikView

[nacera_abbas]

Thank you, I will take a look at this