Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a pivot table with a calculated dimension, and am trying to get percentages to the calculated dimension level.
Collapsed, the percentages are fine. Expanded, '-' populated cells show up. I've worked over aggr with this with no luck. Sample aggr:
(sum(total_claim_count) / (aggr(sum(claim_count), claim_name, claim_status))
The calculated dimension involves three 'if' statements and does not plug into the aggr.
This has used up my blood on the keyboard supply for the weekend.
Help vastly appreciated.
Go to Solution.
The solution is:
(sum(total_claim_count) / (aggr(nodistinct sum(claim_count), claim_name, claim_status))
nodistinct is what does the trick!
I understand ur problem. Better attach ur here?
Thank You. Thank You. Thank You!
Why, nodistinct does the trick ?