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

    Only display last 6 weeks



      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?