7 Replies Latest reply: Sep 3, 2014 5:56 AM by Sailee Kumawat RSS

    Week Over Week Change

      Hi ,

       

      I need to show a table in my qlikview dashboard , where , the current weeks values are compared with last weeks value . E.g. Monday this week and monday last week. I need to show it in the format displayed beloow. I tried using reangesum , But it breaks as soon as i get Week Start Date dimesion in the chart. Can someone please help here ?

       

      Week Start DateDateCurrent Week Previous Week
      8/3/20148/3/2014109
      8/3/20148/4/20142012
      8/3/20148/5/20143014
      8/3/20148/6/20141115
      8/3/20148/7/2014236
      8/3/20148/8/2014344
      8/3/20148/9/2014320
      8/10/20148/10/20143510
      8/10/20148/11/20143920
      8/10/20148/12/20144230
      8/10/20148/13/20144511
      8/10/20148/14/20144823
      8/10/20148/15/20145134
      8/10/20148/16/20145432
      8/17/20148/17/20145735
      8/17/20148/18/20146139
      8/17/20148/19/20146442
      8/17/20148/20/20146745
      8/17/20148/21/20147048
      8/17/20148/22/20147351
      8/17/20148/23/20147654
      8/24/20148/24/20143557
      8/24/20148/25/20143961
      8/24/20148/26/20144264
      8/24/20148/27/20144567
      8/24/20148/28/20143570
      8/24/20148/29/20143973
      8/24/20148/30/20144276

       

      Thanks,

      Sailee

        • Re: Week Over Week Change
          Manish Kachhia

          Can you elaborate little more please?

            • Re: Week Over Week Change

              HI Manish,

               

              Basically , I want to show measure of current week days and last week days against current week dates ..Check the values in bold. In week of 8/3/2014, on first day value was 10. This value should appear as previous week value on first day of week of 8/10/2014.

               

              Week Start DateDateCurrent Week ValuesPrevious Week Values
              8/3/20148/3/2014109
              8/3/20148/4/20142012
              8/3/20148/5/20143014
              8/3/20148/6/20141115
              8/3/20148/7/2014236
              8/3/20148/8/2014344
              8/3/20148/9/2014320
              8/10/20148/10/20143510
              8/10/20148/11/20143920
              8/10/20148/12/20144230
              8/10/20148/13/20144511
              8/10/20148/14/20144823
              8/10/20148/15/20145134
              8/10/20148/16/20145432

               

              I hope this clarifies.

               

              Thanks,
              Sailee

                • Re: Week Over Week Change
                  Adrian Buzer

                  Using Date as the dimension your first expression would simply be:

                  Sum(Amount)

                  And as long as you are loading the dates with numerical values (ie 8/3/14 = 41706 etc) then your second expression would be Sum({<Date={$(=Only(Date)-7}>}Amount)

                  Then you could compare by using Column(2) - Column(1) in a 3rd expression

                  • Re: Week Over Week Change
                    Manish Kachhia

                    Temp:

                    Load

                      Date(Date#([Week Start Date],'M/D/YYYY')) as [Week Start Date] ,

                      Date(Date#(Date,'M/D/YYYY')) as Date,

                      [Current Week],

                      [Previous Week],

                      Date(Date#(Date,'M/D/YYYY')-7) as PreviousWeekDate

                    Inline

                    [

                      Week Start Date, Date, Current Week, Previous Week

                      8/3/2014, 8/3/2014, 10, 9

                      8/3/2014, 8/4/2014, 20, 12

                      8/3/2014, 8/5/2014, 30, 14

                      8/3/2014, 8/6/2014, 11, 15

                      8/3/2014, 8/7/2014, 23, 6

                      8/3/2014, 8/8/2014, 34, 4

                      8/3/2014, 8/9/2014, 32, 0

                      8/10/2014, 8/10/2014, 35, 10

                      8/10/2014, 8/11/2014, 39, 20

                      8/10/2014, 8/12/2014, 42, 30

                      8/10/2014, 8/13/2014, 45, 11

                      8/10/2014, 8/14/2014, 48, 23

                      8/10/2014, 8/15/2014, 51, 34

                      8/10/2014, 8/16/2014, 54, 32

                      8/17/2014, 8/17/2014, 57, 35

                      8/17/2014, 8/18/2014, 61, 39

                      8/17/2014, 8/19/2014, 64, 42

                      8/17/2014, 8/20/2014, 67, 45

                      8/17/2014, 8/21/2014, 70, 48

                      8/17/2014, 8/22/2014, 73, 51

                      8/17/2014, 8/23/2014, 76, 54

                      8/24/2014, 8/24/2014, 35, 57

                      8/24/2014, 8/25/2014, 39, 61

                      8/24/2014, 8/26/2014, 42, 64

                      8/24/2014, 8/27/2014, 45, 67

                      8/24/2014, 8/28/2014, 35, 70

                      8/24/2014, 8/29/2014, 39, 73

                      8/24/2014, 8/30/2014, 42, 76

                    ];

                     

                     

                    Join

                     

                     

                    Load

                      Date as PreviousWeekDate,

                      [Current Week] as PWEEK

                    Resident Temp;

                     

                     

                    PWEEK is your required field and compare it with [Previous Week]