Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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") 😉