Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

leomathew
Contributor

Chart help?

Hi

please suggest the solution?

offset.jpg

this needs to be done using chart expresssions.

thanks for help

1 Solution

Accepted Solutions
Highlighted

Re: Chart help?

Try this expression:

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


Capture.PNG

View solution in original post

2 Replies
Highlighted

Re: Chart help?

Try this expression:

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


Capture.PNG

View solution in original post

Highlighted
leomathew
Contributor

Re: Chart help?

Quite close, it worked.

Thanks