Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis Question

Hi,

I use a variable called vToday that contains a date e.g. 06.08.2009

I tried this:

sum({$<Datefield = {"$(vToday)"}>} Sales)

This isn't working.

If I use sum({$<Datefield = {">=$(vToday)"}>} Sales), it I'm getting the correct sum.

can someone please tell me why the first approach doesn't work. Thanks

Aloah

1 Reply
eiconsulting
Partner - Creator II
Partner - Creator II

May I suppose that it is a problem with the date format? To be sure pls check.

I cannot reproduce it, though if I use 06/08/2009 it works perfectly right with both your expressions. With your 06.08.2009 behaves strange.

Flavio

Federico Sason | Emanuele Briscolini