Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Saro_2306
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
MayilVahanan

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
Saro_2306
Contributor II
Contributor II
Author

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

MayilVahanan

HI Saro

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

Thanks & Regards,
Mayil Vahanan R
Saro_2306
Contributor II
Contributor II
Author

No, Its not working all values showing "0"

MayilVahanan

Hi Saro,

Can you please provide your sample file to proceed further

Thanks & Regards,
Mayil Vahanan R