topic Re: Pivot chart sub total expressions clarification in QlikView https://community.qlik.com/t5/QlikView/Pivot-chart-sub-total-expressions-clarification/m-p/265340#M583385 <HTML><HEAD></HEAD><BODY><P>Please check the attachment</P></BODY></HTML> Fri, 21 Oct 2011 09:56:43 GMT 2011-10-21T09:56:43Z Pivot chart sub total expressions clarification https://community.qlik.com/t5/QlikView/Pivot-chart-sub-total-expressions-clarification/m-p/265339#M583384 <HTML><HEAD></HEAD><BODY><P>In Pivot chart, I have dimension (location,item) , expressions(quantity,value). Here, I have value but quantity is zero for some items. I need to cut this value when quantity is zero. after that sub total(show partial columns - by checked) is having the total value(including value of zero quantity). So please give me suggestions.</P><P>my expression for Qunatity is == sum(PQTY-MQTY)</P><P>my expression for Value is == sum(PSTOCKVALUE-MSTOCKVALUE)</P><P>Expecting your reply.</P><P></P><P>pls help me to solve the issue</P><P></P><P></P><P>Thanks</P><P>Kumar</P></BODY></HTML> Fri, 21 Oct 2011 09:26:56 GMT https://community.qlik.com/t5/QlikView/Pivot-chart-sub-total-expressions-clarification/m-p/265339#M583384 2011-10-21T09:26:56Z Re: Pivot chart sub total expressions clarification https://community.qlik.com/t5/QlikView/Pivot-chart-sub-total-expressions-clarification/m-p/265340#M583385 <HTML><HEAD></HEAD><BODY><P>Please check the attachment</P></BODY></HTML> Fri, 21 Oct 2011 09:56:43 GMT https://community.qlik.com/t5/QlikView/Pivot-chart-sub-total-expressions-clarification/m-p/265340#M583385 2011-10-21T09:56:43Z Pivot chart sub total expressions clarification https://community.qlik.com/t5/QlikView/Pivot-chart-sub-total-expressions-clarification/m-p/265341#M583386 <HTML><HEAD></HEAD><BODY><P>hi </P><P></P><P>thank u very much.</P><P>its working dear.</P><P>really great.</P><P></P><P>thanks</P><P>kumar</P></BODY></HTML> Fri, 21 Oct 2011 10:03:05 GMT https://community.qlik.com/t5/QlikView/Pivot-chart-sub-total-expressions-clarification/m-p/265341#M583386 2011-10-21T10:03:05Z