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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Vittore8
Creator
Creator

Date interval

Good day, please tell me how I can add an interval in set analysis? 

For example there is a field: date

How can I get the dates that are in this range 2020-01 to 2020-12?

 

Labels (1)
1 Reply
Taoufiq_Zarra

One Example : for sum sales

=sum({< date = {">=$(=date('2020-01','YYYY-MM')) <=$(=date('2020-12','YYYY-MM')) "} >} Sales)

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉