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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
gilldilpreet
Contributor III
Contributor III

Changing date to variable in set analysis

Hi,

I am trying to change the dates in the expression below to variables i.e. today() and today()-1 and today()-2 etc.

I have tried using the expression underlined in red but this doesn't seem to be working. 

Could someone advise please? 

gilldilpreet_0-1601982169627.png

Thanks 

Dilpreet

1 Solution

Accepted Solutions
Taoufiq_Zarra

@gilldilpreet  Like :

sum({<[Session Date]={"$(=Date(today(),'DD/MM/YYYY'))"},....>}

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

1 Reply
Taoufiq_Zarra

@gilldilpreet  Like :

sum({<[Session Date]={"$(=Date(today(),'DD/MM/YYYY'))"},....>}

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉