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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
shasha3006
Contributor
Contributor

Set Analysis Less than Date

Hi Good People,

want to ask, 

I want to create a set analysis  for results dated less than 12 months from the current date

this Is my script :

registered_date={"$(=Date(addmonths(MonthStart(Max(MakeDate(Year, Month))),-12),'YYYY-MM-DD'))"}

but, this didn't working.

can anyone help?

thanks 

 

 

Labels (2)
10 Replies
shasha3006
Contributor
Contributor
Author

dear @vinieme12 ,

i have try, and result below

shasha3006_1-1679909693686.png