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: 
Not applicable

date range - setdateyear

analyzing a set of data between 2 dates

achieved for the current year:

Count (if ((Created-ReportFromDate)>=0 AND (ReportToDate-Created>=0), Description))


but when I try to apply the same logic for the previous year by using the setdateyear function, it does not work anymore

Count (if (((SetDateYear([Created],2010)-SetDateYear(ReportFromDate,2010))>=0 AND (SetDateYear(ReportToDate,2010)-SetDateYear([Created],2010))>=0), Description))


Any idea?

QV PE 10

0 Replies