topic Re: SUM Function in QlikView

SUM Function

upaliwije — Sun, 23 Mar 2014 11:22:35 GMT

Dear Friends

sum(if (TRAN_TYPE='NEW', 1,if(TRAN_TYPE='RENEWAL',1))AND if(IsNull(Sent_Date)=0)

I have done above expression but it is not working. My expected result is

If TRAN_TYPE='NEW', or 'RENEWAL' one record should be summed provided Sent_Date is not null

Pls help me.

its_anandrjs — Sun, 23 Mar 2014 11:57:18 GMT

Hi,

Write like

=sum(if(Match(TRAN_TYPE,'NEW','RENEWAL') AND IsNull(Sent_Date)=0,Value))

and i think your syntax in missing some identity please check that one, also if possible provide any sample data.

Hope this helps

Thanks & Regards

MarcoWedel — Sun, 23 Mar 2014 12:00:50 GMT

sum(if ((TRAN_TYPE='NEW' OR TRAN_TYPE='RENEWAL') AND IsNull(Sent_Date)=0, 1))

regards

Marco

its_anandrjs — Sun, 23 Mar 2014 12:09:32 GMT

Hi,

Yes you may write some thing this also

=sum(if(Match(TRAN_TYPE,'NEW','RENEWAL') AND IsNull(Sent_Date)=0,1))

Hope this helps

Thanks & Regards

upaliwije — Sun, 23 Mar 2014 12:23:44 GMT

Thanks a lot

MarcoWedel — Sun, 23 Mar 2014 21:22:48 GMT

you're welcome