topic Use condition inside Sum() in QlikView

Use condition inside Sum()

Anonymous — Thu, 13 Jul 2017 15:56:08 GMT

I want to display the savings value corresponding to a particular date using an expression.

I tried using the below expression but it's not working.

sum(

if(

date(TimeStamp#([processed_date],'YYYY-MM-DD hh:mm:ss.s'),'DD/MM/YYYY')))= date(TimeStamp#('2017-01-02 00:00:00.0','YYYY-MM-DD hh:mm:ss.s'),'DD/MM/YYYY'))),

[Savings],

))

can anyone help on this pls?

Re: Use condition inside Sum()

stigchel — Thu, 13 Jul 2017 16:10:50 GMT

If the time of the particular date is of no interest, I would suggest to floor (removing the time portion) the date before comparing. See also

Rounding Errors

Re: Use condition inside Sum()

antoniotiman — Thu, 13 Jul 2017 16:11:17 GMT

Hi Faris,

try this

=sum(
if(
date(TimeStamp#([processed_date],'YYYY-MM-DD hh:mm:ss.f'),'DD/MM/YYYY')
= date(TimeStamp#('2017-01-02 00:00:00.0','YYYY-MM-DD hh:mm:ss.f'),'DD/MM/YYYY'),
[Savings],
0
))

Regards,

Antonio