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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

set analysis and variable

once i think i have this under the belt, i just don't.

i want to use set analysis to based on variable.

the variable is today's date called vdate.

i want sum of sales where salesdate = vdate.

help please?

Lambert Badenhorst.

6 Replies
SunilChauhan
Champion II
Champion II

use below

sum({<salesdate ={"$(vdate)"}>}sales)

Sunil Chauhan
Not applicable
Author

Hi Lambert,

try sum({<salesdate={$(#vdate)}>} sales) or sum({<salesdate={$(#=date(today()))}>} sales)

C u,

Stefano

Not applicable
Author

thank you!

Not applicable
Author

thank you!

Not applicable
Author

thank you!

jcampbell
Partner - Creator
Partner - Creator

This worked perfectly for an expression I was working on. Thanks!