6 Replies Latest reply: Sep 21, 2016 11:09 AM by Guillermo Lo-Kioeng-Shioe RSS

    How to presentate results of the last 3 months

    Guillermo Lo-Kioeng-Shioe

      Hi,

       

      Im trying to set up a report in Qlikview to present the results of the last 3 months. However I dont seem to get this working.

       

      In another report where i'm presenting the last 6 weeks it works like this:

       

      =sum( {$<Week = {$(=Max(Week)-5)}>} Revenues)

       

      But when i replace week with month that doesnt work. Anyone got any idea's?

       

      Thanks in advance.