Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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