Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Qlik Sense Point In Time YTD

Morning all

Can anyone suggest how I can adapt the set analysis below to include the value of a variable "vPoint_In_Time" which will allow a user to enter a date into the variable (using the extension qsVariable) which will then change the YTD based on that variable date?

SUM({$<Date = {'>=$(=YearStart(Today()-1,0,4))<=$(=Date(Today()-1))'}>}Sales)

I'm guessing you have to change the "Today()" part but I can't seem to find the right context to replace it with the variable.