4 Replies Latest reply: Dec 20, 2013 8:05 AM by glen sibley RSS

    Max Date Help

      Hello

       

      I am new to Qlikview, so apologies in advance if my question appears a little clumsy.

       

      I have a very large table (over 5,000,000 records)  and would like to organise my data by flagging which Contract Account numbers have received a letter in a the past 6 months (Run Date). I would like to know the best way to use the max of the Run Date field to create a list box where I filter between over and under 6 months (since the last Run Date).

       

      Any help would be hugely appreciated.


      Thanks,


      Glen