topic yesterday using today() in set analysis in QlikView

yesterday using today() in set analysis

Mon, 26 Jan 2026 18:19:17 GMT

Hello,

I am attempting to use today() to get the value of yesterday in set analysis. I am getting a value for the expression below however, I do not believe it is correct. Basically I am attempting to sum sales where EndDate is greater than or equal to yesterday.

=sum({$<EndDate={">=$(=today(),-1)"}>} Sales)

Any help, or validation would be greatly appreciated.

Thanks much,

Jeff

yesterday using today() in set analysis

johnw — Fri, 29 Jan 2010 19:05:28 GMT

Looks like a syntax error to me - it shouldn't allow the comma after today(). Assuming that's just a typo when posting, it looks right to me. However, you may need to format the result as a date of the same format as EndDate. So, for instance, if EndDate has a format of 'DD/MM/YY', you may need to use sum({<EndDate={">=$(=date(today()-1,'DD/MM/YY'))"}>} Sales). Set analysis isn't very good with date comparisons, and needs the formats to match in order to recognize they're the same, unlike an if() statement, for instance.