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: 
GrizzlyBestia
Contributor II
Contributor II

How can I restrict calendar variable >= than a selected date in an expression?

Hi there,

I am trying to restrict a calendar date variable using set analysis but struggling to get any formulas to work with a date.

{<[Cal Date]={">=$(='$(vReportingDateMonthly)')<$(=Addmonths(date('$(vReportingDateMonthly)'),12))"}>}

This set analysis shows Cal Date >= 15/03/2021 < 15/03/2022. How can I apply this analysis to my calendar date variable?

WeekYear([$(vPrefix) W/C Date])&'-'&Num(Week([$(vPrefix) W/C Date]), '00') as [Supply BirthYear/Week]

 

This variable goes back to 2020 -WK47. I want it to match Cal Date >= 15/03/2021 < 15/03/2022

0 Replies