15 Replies Latest reply: Sep 7, 2017 6:25 AM by Apoorva SD RSS

    How to pick up last week's data of that particular month in QlikView?

    Apoorva SD

      Hello Everyone,

       

      I need help on the below requirement.

       

      I have a date field which has dates of only Fridays of that particular month. So this field will have 4 or 5 date values for a month based on number of Fridays in that month. What I want to achieve is, there are AOP and Actual figures against these dates, and in my straight table I would like to display only the data of last week in that particular month. And for the current month, data should be the latest week data.

       

      For Example: Considering that below is the table in excel sheet, I want to display only data for AOP and Actuals for Date, 25-08-2017 for month of August and for September, I have to show data for Date, 01-09-2017 as this is the latest week in September so far.

       

      DateAOPActuals
      04-08-2017755585
      11-08-201738954
      18-08-2017876766
      25-08-201725686
      01-09-2017784233
      08-09-2017265-
      15-09-2017987-

       

      How can I show this data in a Straight table? Any suggestions?

       

      Thank you.