Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

leomathew
New Contributor III

Chart help?

Hi

please suggest the solution?

offset.jpg

this needs to be done using chart expresssions.

thanks for help

1 Solution

Accepted Solutions

Re: Chart help?

Try this expression:

=If(Prod = 'All', Sum(TOTAL Value), Sum(TOTAL Value)-RangeSum(Above(Sum(Value), 0, RowNo()-1)))


Capture.PNG

2 Replies

Re: Chart help?

Try this expression:

=If(Prod = 'All', Sum(TOTAL Value), Sum(TOTAL Value)-RangeSum(Above(Sum(Value), 0, RowNo()-1)))


Capture.PNG

leomathew
New Contributor III

Re: Chart help?

Quite close, it worked.

Thanks

Community Browser