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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
sersal10
Creator
Creator

filter date until this day last year

Hi, I have a table with the accumulated sold tickets, and the date in the x axis. I am wondering how to filter so that only appears the accumulated sales till this day last year. 2023/02/19 for instance. The field is calle accumulative_sales

Thanks,

 

Sergio

Labels (1)
1 Reply
theoat
Partner - Specialist
Partner - Specialist

You can try this set analysis. To be added to your measure.
{<Date={">= addyears(today(),-1)"}>}

Kind regards,
Théo ATRAGIE.