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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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