topic Re: Use current/Prior year in Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Use-current-Prior-year-in-Set-Analysis/m-p/33062#M5580 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><STRONG>=Count({&lt;Month,Year = {"$(=If(Year(AddMonths(AsOfDate, -1)) = Year(AddMonths(AsOfDate, 0)), Year(AddMonths(AsOfDate, 0)), Year(AddMonths(AsOfDate, -1))))"}&gt;} Products)</STRONG></P></BODY></HTML> Thu, 15 Feb 2018 19:03:38 GMT sunny_talwar 2018-02-15T19:03:38Z Use current/Prior year in Set Analysis https://community.qlik.com/t5/QlikView/Use-current-Prior-year-in-Set-Analysis/m-p/33061#M5579 <HTML><HEAD></HEAD><BODY><P>When I use the following in a text box the result displayed is 2017 (or 2018, depending on AsOfDate) :</P><P></P><P>=If(Year(AddMonths(AsOfDate,-1))=Year(AddMonths(AsOfDate,0)),Year(AddMonths(AsOfDate,0)),Year(AddMonths(AsOfDate,-1)))</P><P></P><P>I need to use this in a set analysis statement, though. I tried the following without success:</P><P></P><P>=Count( { &lt;Month=,Year-{"=If(Year(AddMonths(AsOfDate,-1))=Year(AddMonths(AsOfDate,0)),Year(AddMonths(AsOfDate,0)),Year(AddMonths(AsOfDate,-1)))"} &gt;} Products)</P><P></P><P>TIA</P></BODY></HTML> Thu, 15 Feb 2018 18:56:28 GMT https://community.qlik.com/t5/QlikView/Use-current-Prior-year-in-Set-Analysis/m-p/33061#M5579 nickedw0 2018-02-15T18:56:28Z Re: Use current/Prior year in Set Analysis https://community.qlik.com/t5/QlikView/Use-current-Prior-year-in-Set-Analysis/m-p/33062#M5580 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><STRONG>=Count({&lt;Month,Year = {"$(=If(Year(AddMonths(AsOfDate, -1)) = Year(AddMonths(AsOfDate, 0)), Year(AddMonths(AsOfDate, 0)), Year(AddMonths(AsOfDate, -1))))"}&gt;} Products)</STRONG></P></BODY></HTML> Thu, 15 Feb 2018 19:03:38 GMT https://community.qlik.com/t5/QlikView/Use-current-Prior-year-in-Set-Analysis/m-p/33062#M5580 sunny_talwar 2018-02-15T19:03:38Z