Discussion Board for collaboration related to Creating Analytics for QlikView.
I have a problem here regarding RangeSum set analysis in Pivot Table.
Below table is the output i want and the input is the first 4 columns. The final column is the accumalation of the STO needs on product level.
I want to use set analysis to achieve this output. So i used RangeSum function.
When i only add "Product "and "STO _NO" dimensions in the pivot table, the analysis i wrote "rangeSum(Sum(STO_Needs),Above(Accumalation))" works as i expected. But when i added the third dimension "DC_NO", this set analysis didn't work.
Could someone help here?
Attached is the QVW file you can work on.
Your question sounds(to me) in two possible ways:
- You think that this might not work (if so, please let me know why. I would give another try to fix that)
- You might not have understood some of the section of the expression (if so, please let me know exactly which section you need clarification with).
Hi thanks for the reply, it's the latter, the expression you post contains this: If(Product=Above(Total Product)
which was added to let the formula work, I don't understand why we need to add this part to let it work. Thanks!
Without If(Product=Above(Total Product),you would notice that the accumulation would happen across Product dimension, i.e. - irrespective of product the accumulation goes adding up start to end. However, with this code we are checking if there is a change in product value in dimension. If there is a new product then we are resetting the accumulation with zero reference to the earlier value.
Hope this helps.