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

       

      =max({<Year(LastAccess)={'2014'}>}LastAccess)

       

      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?

       

      Regards,

      Tejas