5 Replies Latest reply: Jul 19, 2016 9:18 AM by Sindhu Neelisetty RSS

    Issue in generating Rolling weekly reports.

    Sindhu Neelisetty

      Hi All,

       

      I wanted to generate report based on Weekly, 6 Weeks, and Quaterly

       

      Below is an example data

       

      MonthWeek StartNext weekLast week6 weeksQuarter to dateWeekly Count6 weeks Count

      Quarter

      To Date

      Count

      16-Jul7/4/20167/11/20166/27/20165/30/20167/1/20161101
      16-Jun6/27/20167/4/20166/20/20165/23/20164/1/201621331
      16-Jun6/20/20166/27/20166/13/20165/16/20164/1/201611629
      16-Jun6/13/20166/20/20166/6/20165/9/20164/1/201631628
      16-Jun6/6/20166/13/20165/30/20165/2/20164/1/201611525
      16-May5/30/20166/6/20165/23/20164/25/20164/1/201621824
      16-May5/23/20165/30/20165/16/20164/18/20164/1/201641722
      16-May5/16/20165/23/20165/9/20164/11/20164/1/201651518
      16-May5/9/20165/16/20165/2/20164/4/20164/1/201611313
      16-May5/2/20165/9/20164/25/20163/28/20164/1/201621312
      16-Apr4/25/20165/2/20164/18/20163/21/20164/1/201641610
      16-Apr4/18/20164/25/20164/11/20163/14/20164/1/20161126
      16-Apr4/11/20164/18/20164/4/20163/7/20164/1/20162115
      16-Apr4/4/20164/11/20163/28/20162/29/20164/1/2016393
      16-Mar3/28/20164/4/20163/21/20162/22/20161/1/2016166
      16-Mar3/21/20163/28/20163/14/20162/15/20161/1/2016555

       

      The Weekly Count is sum(Counts) dates between Week Start column and Less than Next Week column

      The 6 Weekly Count is sum of counts dates between the  6 Weeks column and less than Next Week Column

      The Quarter To Date Count is sum of counts dates between the Quarter to date column and less than Next Week Column

       

       

      The report in qlikview should be as follows:

               

           

      MonthWeek StartWeekly Count6 weeks CountQuarter To Date Count
      16-Jul7/4/20161101
      16-Jun6/27/201621331
      16-Jun6/20/201611629
      16-Jun6/13/201631628
      16-Jun6/6/201611525
      16-May5/30/201621824
      16-May5/23/201641722
      16-May5/16/201651518
      16-May5/9/201611313
      16-May5/2/201621312
      16-Apr4/25/201641610
      16-Apr4/18/20161126
      16-Apr4/11/20162115
      16-Apr4/4/2016393
      16-Mar3/28/2016166
      16-Mar3/21/2016555

       

      Can you help how can I show the weekly,6 weekly and quarter to date report in one chart.

      help me with the expression to use.

       

      I am using the master calendar with flags V1.5  https://community.qlik.com/docs/DOC-13536

       

       

      richard.pearce