topic Re: Chart help? in QlikView https://community.qlik.com/t5/QlikView/Chart-help/m-p/1079587#M524092 <HTML><HEAD></HEAD><BODY><P>Quite close, it worked.</P><P>Thanks </P></BODY></HTML> Sun, 28 Feb 2016 13:52:48 GMT Vidit 2016-02-28T13:52:48Z Chart help? https://community.qlik.com/t5/QlikView/Chart-help/m-p/1079585#M524090 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>please suggest the solution?</P><P><IMG alt="offset.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/115376_offset.jpg" style="height: auto;" /></P><P>this needs to be done using chart expresssions.</P><P>thanks for help</P></BODY></HTML> Sun, 21 Feb 2016 21:02:55 GMT https://community.qlik.com/t5/QlikView/Chart-help/m-p/1079585#M524090 Vidit 2016-02-21T21:02:55Z Re: Chart help? https://community.qlik.com/t5/QlikView/Chart-help/m-p/1079586#M524091 <HTML><HEAD></HEAD><BODY><P>Try this expression:</P><P></P><P><STRONG>=If(Prod = 'All', Sum(TOTAL Value), Sum(TOTAL Value)-RangeSum(Above(Sum(Value), 0, RowNo()-1)))</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG __jive_id="115382" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/115382_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Sun, 21 Feb 2016 22:12:17 GMT https://community.qlik.com/t5/QlikView/Chart-help/m-p/1079586#M524091 sunny_talwar 2016-02-21T22:12:17Z Re: Chart help? https://community.qlik.com/t5/QlikView/Chart-help/m-p/1079587#M524092 <HTML><HEAD></HEAD><BODY><P>Quite close, it worked.</P><P>Thanks </P></BODY></HTML> Sun, 28 Feb 2016 13:52:48 GMT https://community.qlik.com/t5/QlikView/Chart-help/m-p/1079587#M524092 Vidit 2016-02-28T13:52:48Z