4 Replies Latest reply: Jan 8, 2016 6:12 AM by Sunny Talwar RSS

    Getting familiar with SET analysis

      Hi Folks,


      I am very much new to QlikView.


      I am trying to achieve something like below:


      I want to get maximum LastAccess(date) for the year 2014




      For some reason this formula does not give any data back.


      However when apply max(if(year(LastAccess)=2014,LastAccess)), it works.


      Is there something I am missing?