topic Re: expression in QlikView https://community.qlik.com/t5/QlikView/expression/m-p/764443#M271734 <HTML><HEAD></HEAD><BODY><P>thanks</P></BODY></HTML> Sun, 08 Feb 2015 09:38:28 GMT upaliwije 2015-02-08T09:38:28Z expression https://community.qlik.com/t5/QlikView/expression/m-p/764440#M271731 <HTML><HEAD></HEAD><BODY><P>HI,</P><P></P><P>I have two fields in my pivot table</P><P></P><P>Sent_Date</P><P>Amount</P><P></P><P>I want to write an expression to sum the amount where sent_date is not null</P><P></P><P>Pls help me</P></BODY></HTML> Sun, 08 Feb 2015 08:26:50 GMT https://community.qlik.com/t5/QlikView/expression/m-p/764440#M271731 upaliwije 2015-02-08T08:26:50Z Re: expression https://community.qlik.com/t5/QlikView/expression/m-p/764441#M271732 <HTML><HEAD></HEAD><BODY><P>Create a flag in your load script as follow:</P><P></P><P>if(isNull(sent_date),'1',sent_date) as sent_date_flag</P><P></P><P>In you expression then: If(sent__date='1',' ', sum(Amount))</P></BODY></HTML> Sun, 08 Feb 2015 09:21:29 GMT https://community.qlik.com/t5/QlikView/expression/m-p/764441#M271732 terezagr 2015-02-08T09:21:29Z Re: expression https://community.qlik.com/t5/QlikView/expression/m-p/764442#M271733 <HTML><HEAD></HEAD><BODY><P>Like this?</P><P></P><P><SPAN style="font-family: courier new,courier;">=sum(IF (Not IsNull(Sent_Date), Amount))</SPAN></P></BODY></HTML> Sun, 08 Feb 2015 09:21:39 GMT https://community.qlik.com/t5/QlikView/expression/m-p/764442#M271733 Peter_Cammaert 2015-02-08T09:21:39Z Re: expression https://community.qlik.com/t5/QlikView/expression/m-p/764443#M271734 <HTML><HEAD></HEAD><BODY><P>thanks</P></BODY></HTML> Sun, 08 Feb 2015 09:38:28 GMT https://community.qlik.com/t5/QlikView/expression/m-p/764443#M271734 upaliwije 2015-02-08T09:38:28Z