topic Pivot chart sub total expressions in QlikView https://community.qlik.com/t5/QlikView/Pivot-chart-sub-total-expressions/m-p/265319#M583391 <HTML><HEAD></HEAD><BODY><P>pls give sugesstons</P><P></P><P>kumar</P></BODY></HTML> Fri, 21 Oct 2011 09:10:08 GMT 2011-10-21T09:10:08Z Pivot chart sub total expressions https://community.qlik.com/t5/QlikView/Pivot-chart-sub-total-expressions/m-p/265316#M583388 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><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></P><P></P><P>kumar</P></BODY></HTML> Fri, 21 Oct 2011 08:49:12 GMT https://community.qlik.com/t5/QlikView/Pivot-chart-sub-total-expressions/m-p/265316#M583388 2011-10-21T08:49:12Z Re: Pivot chart sub total expressions https://community.qlik.com/t5/QlikView/Pivot-chart-sub-total-expressions/m-p/265317#M583389 <HTML><HEAD></HEAD><BODY><P>Does this help?</P><P></P><P>Kiran.</P></BODY></HTML> Fri, 21 Oct 2011 08:57:33 GMT https://community.qlik.com/t5/QlikView/Pivot-chart-sub-total-expressions/m-p/265317#M583389 2011-10-21T08:57:33Z Pivot chart sub total expressions https://community.qlik.com/t5/QlikView/Pivot-chart-sub-total-expressions/m-p/265318#M583390 <HTML><HEAD></HEAD><BODY><P>YES. PLZ HELP ME.</P><P></P><P>KUMAR</P></BODY></HTML> Fri, 21 Oct 2011 09:03:54 GMT https://community.qlik.com/t5/QlikView/Pivot-chart-sub-total-expressions/m-p/265318#M583390 2011-10-21T09:03:54Z Pivot chart sub total expressions https://community.qlik.com/t5/QlikView/Pivot-chart-sub-total-expressions/m-p/265319#M583391 <HTML><HEAD></HEAD><BODY><P>pls give sugesstons</P><P></P><P>kumar</P></BODY></HTML> Fri, 21 Oct 2011 09:10:08 GMT https://community.qlik.com/t5/QlikView/Pivot-chart-sub-total-expressions/m-p/265319#M583391 2011-10-21T09:10:08Z Pivot chart sub total expressions https://community.qlik.com/t5/QlikView/Pivot-chart-sub-total-expressions/m-p/265320#M583392 <HTML><HEAD></HEAD><BODY><P>Please check out the attachment I included.</P></BODY></HTML> Fri, 21 Oct 2011 10:37:10 GMT https://community.qlik.com/t5/QlikView/Pivot-chart-sub-total-expressions/m-p/265320#M583392 2011-10-21T10:37:10Z