Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Accumulation in Pivot Table

Hi all,

 

I need to calculate YTD value in the pivot table with 3 dimensions, as below. I cant able to write an expression for this. anybody, please help me. Thanks in advance.

 

D1D2D3ABDE(A/B) / (D/E)YTD
2011IndiaDelhi100250222
2011PakKarachi20051001044
2012IndiaDelhi3003200424
2012PakKarachi4004150326
2013IndiaDelhi5002250559
2013PakKarachi6003300328
Labels (2)
5 Replies
Highlighted

Hi Saro,

Try like below

RangeSum(
Aggr(
RangeSum(Above(Sum([(A/B) / (D/E)]), 0, RowNo())), D3, D2, D1))


Sample Output:

1753442.PNG

 Hope it helps.

Thanks & Regards,
Mayil Vahanan R
Highlighted
Contributor II
Contributor II

Thanks Bro, Will it works for Calculated expression. Bcs in my case all A, B, D, E are calculated expressions.

Highlighted

HI Saro

Yes, it will work.
Replace A,B,D,E with your expressions

Thanks & Regards,
Mayil Vahanan R
Highlighted
Contributor II
Contributor II

No, Its not working all values showing "0"

Highlighted

Hi Saro,

Can you please provide your sample file to proceed further

Thanks & Regards,
Mayil Vahanan R