19 Replies Latest reply: Jan 10, 2014 2:59 AM by Alex Hamilton McLeod RSS

    Only display last 6 weeks

      HI,

       

      i'm pretty new to Qlikview and am trying to get my head round set analysis. I have a table with 2 columns essentially. One with a date value and the other with a monetay value (Revenue).

       

      I can display a bar chart showing revenue by week, but this shows all data historically going back years. I only want to show the last 6 weeks though on a particular chart, whilst retaining all the data for previous years in the background for another chart.

       

      currently my expression is simply SUM(Revenue). Would I do a set analysis to only display the last 6 weeks? If so, how?