topic Re: Arithmetic Expression in QlikView https://community.qlik.com/t5/QlikView/Arithmetic-Expression/m-p/673911#M1081132 <HTML><HEAD></HEAD><BODY><P>maybe, in a chart,&nbsp; you need some function (aggregation function)</P><P></P><P>sum (<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.727272033691406px;">TP_PREM_LC_1 - TP_DISC_LC_1 + TP_LOAD_LC_1</SPAN>)</P></BODY></HTML> Sun, 29 Jun 2014 07:28:37 GMT maxgro 2014-06-29T07:28:37Z Arithmetic Expression https://community.qlik.com/t5/QlikView/Arithmetic-Expression/m-p/673910#M1081131 <HTML><HEAD></HEAD><BODY><P>Hi Friends !</P><P>I'm having a small doubt in applying the arithmetic expression in qlikview.</P><P>My Expression is =TP_PREM_LC_1 - TP_DISC_LC_1 + TP_LOAD_LC_1.</P><P>when i'm applying this with parenthesis i'm getting null values.Please help me out.</P><P></P><P>Regards</P><P>Krish</P></BODY></HTML> Sun, 29 Jun 2014 06:43:22 GMT https://community.qlik.com/t5/QlikView/Arithmetic-Expression/m-p/673910#M1081131 2014-06-29T06:43:22Z Re: Arithmetic Expression https://community.qlik.com/t5/QlikView/Arithmetic-Expression/m-p/673911#M1081132 <HTML><HEAD></HEAD><BODY><P>maybe, in a chart,&nbsp; you need some function (aggregation function)</P><P></P><P>sum (<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.727272033691406px;">TP_PREM_LC_1 - TP_DISC_LC_1 + TP_LOAD_LC_1</SPAN>)</P></BODY></HTML> Sun, 29 Jun 2014 07:28:37 GMT https://community.qlik.com/t5/QlikView/Arithmetic-Expression/m-p/673911#M1081132 maxgro 2014-06-29T07:28:37Z Re: Arithmetic Expression https://community.qlik.com/t5/QlikView/Arithmetic-Expression/m-p/673912#M1081133 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>May be like this.</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=sum (</SPAN><SPAN style="font-size: 12.727272033691406px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">TP_PREM_LC_1 - TP_DISC_LC_1) +sum( TP_LOAD_LC_1</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Regards</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">ASHFAQ<BR /></SPAN></P></BODY></HTML> Sun, 29 Jun 2014 08:08:21 GMT https://community.qlik.com/t5/QlikView/Arithmetic-Expression/m-p/673912#M1081133 ashfaq_haseeb 2014-06-29T08:08:21Z Re: Arithmetic Expression https://community.qlik.com/t5/QlikView/Arithmetic-Expression/m-p/673913#M1081134 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>May be like this.</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=sum (</SPAN><SPAN style="font-size: 12.727272033691406px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">TP_PREM_LC_1 - TP_DISC_LC_1) +sum( TP_LOAD_LC_1</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Regards</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">ASHFAQ<BR /></SPAN></P></BODY></HTML> Sun, 29 Jun 2014 08:08:49 GMT https://community.qlik.com/t5/QlikView/Arithmetic-Expression/m-p/673913#M1081134 ashfaq_haseeb 2014-06-29T08:08:49Z