Discussion board where members can get started with QlikView.
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.
Try like below
RangeSum(Aggr(RangeSum(Above(Sum([(A/B) / (D/E)]), 0, RowNo())), D3, D2, D1))
Hope it helps.
Thanks Bro, Will it works for Calculated expression. Bcs in my case all A, B, D, E are calculated expressions.
HI SaroYes, it will work.Replace A,B,D,E with your expressions
No, Its not working all values showing "0"
Can you please provide your sample file to proceed further