topic Re: Expression Help in QlikView https://community.qlik.com/t5/QlikView/Expression-Help/m-p/861797#M301626 <HTML><HEAD></HEAD><BODY><P>Any help on the same.</P></BODY></HTML> Wed, 22 Apr 2015 06:21:53 GMT sona_sa 2015-04-22T06:21:53Z Expression Help https://community.qlik.com/t5/QlikView/Expression-Help/m-p/861796#M301625 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000;">Hi,</SPAN></P><P></P><P><SPAN style="color: #000000;">I have a pivot object. For data I have attached QVW file, Please check. </SPAN></P><P><SPAN style="color: #000000;"><BR /></SPAN></P><P><SPAN style="color: #000000;">Now the issue is, For </SPAN></P><P><SPAN style="color: #000000;"><STRONG><BR /></STRONG></SPAN></P><P><SPAN style="color: #000000;"><STRONG>Total ODE --&gt;</STRONG> <STRONG>ODE Class A Items + ODE Class B Items + Advertisement &amp; Sales Promotion</STRONG>. My Calulation is not correct, Where In </SPAN></P><P><SPAN style="color: #000000;"><BR /></SPAN></P><P><SPAN style="color: #000000;">My Expression it is calculating like --&gt;</SPAN></P><P><SPAN style="color: #000000;"><BR /></SPAN></P><P><SPAN style="color: #000000;"><STRONG>ODE Class A Items + ODE Class B Items + Advertisement &amp; Sales Promotion + Exchange (Gain) / Loss + Bad Debts</STRONG> (Which is wrong). </SPAN></P><P><SPAN style="color: #000000;"><BR /></SPAN></P><P><SPAN style="color: #000000;">It should be like --&gt; <STRONG>ODE Class A Items + ODE Class B Items + Advertisement &amp; Sales Promotion</STRONG>.</SPAN></P><P></P><P><SPAN style="color: #000000;"><STRONG>Please suggest what should to do.</STRONG></SPAN></P><P><SPAN style="color: #000000;"><STRONG><BR /></STRONG></SPAN></P><P><SPAN style="color: #000000;"><STRONG>Thanks.</STRONG></SPAN></P></BODY></HTML> Sat, 18 Apr 2015 11:47:56 GMT https://community.qlik.com/t5/QlikView/Expression-Help/m-p/861796#M301625 sona_sa 2015-04-18T11:47:56Z Re: Expression Help https://community.qlik.com/t5/QlikView/Expression-Help/m-p/861797#M301626 <HTML><HEAD></HEAD><BODY><P>Any help on the same.</P></BODY></HTML> Wed, 22 Apr 2015 06:21:53 GMT https://community.qlik.com/t5/QlikView/Expression-Help/m-p/861797#M301626 sona_sa 2015-04-22T06:21:53Z