topic Re: Set Expression on Date not working in QlikView

Set Expression on Date not working

cristian_av — Wed, 25 Nov 2020 16:16:04 GMT

I have a set analysis expression that is always giving me a zero value. I also have an if that gives me the correct value.

How should I write the set analysis for this if expression:

=if(FechaVencimiento<today(),sum(Cargo),0)

This is what i have so far, but giving me always zero values:

=Sum({<FechaVencimiento = {"$(='<' & today())"}>} Cargo)

Thanks!!

sunny_talwar — Wed, 25 Apr 2018 19:54:47 GMT

May be you need to Add date() function with or without format?

=Sum({<FechaVencimiento = {"$(='<' & Date(today()))"}>} Cargo)

=Sum({<FechaVencimiento = {"$(='<' & Date(today(), 'FormatHere'))"}>} Cargo)

cristian_av — Wed, 25 Apr 2018 19:59:39 GMT

Thanks!!

I've added the date in the set expression with no luck, but adding the date in the load script it worked...

Not sure why.!