topic sum(if... problem in QlikView

sum(if... problem

michael_maeuser — Thu, 16 Feb 2012 08:20:26 GMT

Hello, I´m trying to create an expression that shows the values for the last reload date... I´ve been trying this: sum(if(Date=date(reloadtime()), Liq)). It seems to be wrong. I don´t want to work with today() cause there are no values if the script has not been executed today. Any idea? Thanks in advance! Michael

sum(if... problem

vijay_iitkgp — Thu, 16 Feb 2012 08:26:22 GMT

Hi,

It looks like formating error of date.

Please use sum(if(Date(Date,'DD-MM-YYYY')=Date(Reloadtime(),'DD-MM-YYYY'),Liq)). Hope this will work.

sum(if... problem

michael_maeuser — Thu, 16 Feb 2012 08:38:11 GMT

unfortunately it doesn´t work either. i still get 0 as result. but if i make sum(if(Date=Today(), Liq)) i get the correct result (I executed the script today)

sum(if... problem

CELAMBARASAN — Thu, 16 Feb 2012 08:41:40 GMT

Hi,

Can you check the format of date field whether it is in timestamp or normal date?

Celambarasan

sum(if... problem

vijay_iitkgp — Thu, 16 Feb 2012 08:46:29 GMT

Can you use Sum(If(Date=Date(Makedate(Year(Reloadtime()),Month(Reloadtime()),Day(Reloadtime())),Liq))

sum(if... problem

michael_maeuser — Thu, 16 Feb 2012 08:57:03 GMT

thanks so much!!