Discussion Board for collaboration on QlikView Layout & Visualizations.
please suggest the solution?
this needs to be done using chart expresssions.
thanks for help
Try this expression:
=If(Prod = 'All', Sum(TOTAL Value), Sum(TOTAL Value)-RangeSum(Above(Sum(Value), 0, RowNo()-1)))
View solution in original post
Quite close, it worked.