Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
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
Master II
Master II

@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
Master II
Master II

@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