Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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