topic how do find DSO Avg in Combo chart in QlikView https://community.qlik.com/t5/QlikView/how-do-find-DSO-Avg-in-Combo-chart/m-p/284480#M105742 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I need&nbsp; to show&nbsp; Net&nbsp; Sales (Bar) , Net Collection (Bar) &amp; DSO Avg (Line) in Combo Chart.</P><P></P><P>I have taken Net Sales &amp; Collection in Bar but i dont know how to take <SPAN style="color: #ff0000;"><STRONG>DSO Avg</STRONG></SPAN> in Line.</P><P></P><P>The same thing i have done in straight table but i dont know how to do it in Combo Chart ??</P><P></P><P></P><P>DSO formula :&nbsp; </P><P></P><P>Avg Sales = Net Sales (3 months) / 90 or 91 days </P><P></P><P>DSO = Closing Balance / Avg Sales</P><P></P><P></P><P></P><P>Can any one help me.</P><P></P><P></P><P>I have attached my Application.</P><P></P><P></P><P></P><P>Thanks &amp; Regards,</P><P>Antony.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Fri, 19 Aug 2011 05:35:21 GMT 2011-08-19T05:35:21Z how do find DSO Avg in Combo chart https://community.qlik.com/t5/QlikView/how-do-find-DSO-Avg-in-Combo-chart/m-p/284480#M105742 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I need&nbsp; to show&nbsp; Net&nbsp; Sales (Bar) , Net Collection (Bar) &amp; DSO Avg (Line) in Combo Chart.</P><P></P><P>I have taken Net Sales &amp; Collection in Bar but i dont know how to take <SPAN style="color: #ff0000;"><STRONG>DSO Avg</STRONG></SPAN> in Line.</P><P></P><P>The same thing i have done in straight table but i dont know how to do it in Combo Chart ??</P><P></P><P></P><P>DSO formula :&nbsp; </P><P></P><P>Avg Sales = Net Sales (3 months) / 90 or 91 days </P><P></P><P>DSO = Closing Balance / Avg Sales</P><P></P><P></P><P></P><P>Can any one help me.</P><P></P><P></P><P>I have attached my Application.</P><P></P><P></P><P></P><P>Thanks &amp; Regards,</P><P>Antony.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Fri, 19 Aug 2011 05:35:21 GMT https://community.qlik.com/t5/QlikView/how-do-find-DSO-Avg-in-Combo-chart/m-p/284480#M105742 2011-08-19T05:35:21Z how do find DSO Avg in Combo chart https://community.qlik.com/t5/QlikView/how-do-find-DSO-Avg-in-Combo-chart/m-p/284481#M105743 <HTML><HEAD></HEAD><BODY><P>Can Any one Answer for the Above Query...</P></BODY></HTML> Fri, 19 Aug 2011 10:28:49 GMT https://community.qlik.com/t5/QlikView/how-do-find-DSO-Avg-in-Combo-chart/m-p/284481#M105743 2011-08-19T10:28:49Z