9 Replies Latest reply: Jan 7, 2015 4:18 AM by Richard Chilvers RSS

    Comparisons

      Good Morning. I'm new to QLIK and i'm working to a monitoring dashboard of some equitys. This is an example of an equity's load:

       

      Microsoft:

      LOAD year(Date) as Year,

        month(Date) as Month,

        Date,

           Open,

           High,

           Low,

           Close,

           Volume,

           [Adj Close]  ,

           'MICROSOFT' as Azione

       

       

      I would like to compare the close of the equity with the previous closes. For example compare the last close with the close of december to see his trend. How can i do?