topic One expression question in QlikView https://community.qlik.com/t5/QlikView/One-expression-question/m-p/514537#M192196 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>I have an expression..</P><P>Sum (if (IsPurchase = 1,&nbsp; Amount)</P><P>it works fine but i need to do it more...</P><P>the way it works is...</P><P>wherever IsPurchase = 1 it shows the Amount and shows 0 for others...</P><P>what i need is to show blank instead of 0 when conditions do not match.</P><P>I tried null() and text(null()) but it still is showing 0.</P><P>Can I achieve what I want?</P><P>Regards,</P><P>Saurabh</P></BODY></HTML> Tue, 12 Nov 2013 22:10:05 GMT 2013-11-12T22:10:05Z One expression question https://community.qlik.com/t5/QlikView/One-expression-question/m-p/514537#M192196 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>I have an expression..</P><P>Sum (if (IsPurchase = 1,&nbsp; Amount)</P><P>it works fine but i need to do it more...</P><P>the way it works is...</P><P>wherever IsPurchase = 1 it shows the Amount and shows 0 for others...</P><P>what i need is to show blank instead of 0 when conditions do not match.</P><P>I tried null() and text(null()) but it still is showing 0.</P><P>Can I achieve what I want?</P><P>Regards,</P><P>Saurabh</P></BODY></HTML> Tue, 12 Nov 2013 22:10:05 GMT https://community.qlik.com/t5/QlikView/One-expression-question/m-p/514537#M192196 2013-11-12T22:10:05Z Re: One expression question https://community.qlik.com/t5/QlikView/One-expression-question/m-p/514538#M192197 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Sum (if (IsPurchase = 1,&nbsp; Amount,' ')</SPAN></P></BODY></HTML> Tue, 12 Nov 2013 22:13:17 GMT https://community.qlik.com/t5/QlikView/One-expression-question/m-p/514538#M192197 rustyfishbones 2013-11-12T22:13:17Z Re: One expression question https://community.qlik.com/t5/QlikView/One-expression-question/m-p/514539#M192198 <HTML><HEAD></HEAD><BODY><P>Nope, it does not work.</P></BODY></HTML> Tue, 12 Nov 2013 23:24:37 GMT https://community.qlik.com/t5/QlikView/One-expression-question/m-p/514539#M192198 2013-11-12T23:24:37Z Re: One expression question https://community.qlik.com/t5/QlikView/One-expression-question/m-p/514540#M192199 <HTML><HEAD></HEAD><BODY><P>maybe if(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">IsPurchase = 1</SPAN>,sum(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Amount</SPAN>),'') can work</P></BODY></HTML> Tue, 12 Nov 2013 23:28:59 GMT https://community.qlik.com/t5/QlikView/One-expression-question/m-p/514540#M192199 Clever_Anjos 2013-11-12T23:28:59Z Re: One expression question https://community.qlik.com/t5/QlikView/One-expression-question/m-p/514541#M192200 <HTML><HEAD></HEAD><BODY><P>maybe yes</P></BODY></HTML> Tue, 12 Nov 2013 23:31:02 GMT https://community.qlik.com/t5/QlikView/One-expression-question/m-p/514541#M192200 rustyfishbones 2013-11-12T23:31:02Z Re: One expression question https://community.qlik.com/t5/QlikView/One-expression-question/m-p/514542#M192201 <HTML><HEAD></HEAD><BODY><P>It works...Thanks</P></BODY></HTML> Tue, 12 Nov 2013 23:35:36 GMT https://community.qlik.com/t5/QlikView/One-expression-question/m-p/514542#M192201 2013-11-12T23:35:36Z