9 Replies Latest reply: Dec 22, 2015 7:55 AM by Onno van Knotsenburg RSS

    Average hours per week

    GANESH VARA PRASAD JAKULA

      Hi All

      I am new to qlikview, could you please help me in calculating Number of hours per week .

      Pls see the attached excel file with pivot table

        • Re: Average hours per week
          Sunny Talwar

          Is this an extract from QlikView or is this the way your data is structured?

          • Re: Average hours per week
            Jyothish KC

            Hi Ganesh,

             

            PFA app. Hope it will be helpful.

             

            CrossTable(Week, Data)

            LOAD [Row Labels],

                 [1],

                 [2],

                 [3],

                 [4],

                 [5],

                 [6],

                 [7],

                 [8],

                 [9],

                 [10],

                 [11],

                 [12],

                 [13],

                 [14],

                 [15],

                 [16],

                 [17],

                 [18],

                 [19],

                 [20],

                 [21],

                 [22],

                 [23],

                 [24],

                 [25],

                 [26],

                 [27],

                 [28],

                 [29],

                 [30],

                 [31],

                 [32],

                 [33],

                 [34],

                 [35],

                 [36],

                 [37],

                 [38],

                 [39],

                 [40],

                 [41],

                 [42],

                 [43],

                 [44],

                 [45],

                 [46],

                 [47],

                 [48],

                 [Week Number],

                 [(blank)],

                 [Grand Total]

            FROM

            [C:\Users\jykc\Desktop\Copy of Data 2015M11-Nov_RPT.xlsx]

            (ooxml, embedded labels, header is 1 lines, table is Sheet1);

             

            Regards

            KC

            • Re: Average hours per week
              kushal chawda

              Data:

              CrossTable(WeekNumber1, Hours1,1)

              LOAD [Row Labels] as Employee,

                  [1.000000],

                  [2.000000],

                  [3.000000],

                  [4.000000],

                  [5.000000],

                  [6.000000],

                  [7.000000],

                  [8.000000],

                  [9.000000],

                  [10.000000],

                  [11.000000],

                  [12.000000],

                  [13.000000],

                  [14.000000],

                  [15.000000],

                  [16.000000],

                  [17.000000],

                  [18.000000],

                  [19.000000],

                  [20.000000],

                  [21.000000],

                  [22.000000],

                  [23.000000],

                  [24.000000],

                  [25.000000],

                  [26.000000],

                  [27.000000],

                  [28.000000],

                  [29.000000],

                  [30.000000],

                  [31.000000],

                  [32.000000],

                  [33.000000],

                  [34.000000],

                  [35.000000],

                  [36.000000],

                  [37.000000],

                  [38.000000],

                  [39.000000],

                  [40.000000],

                  [41.000000],

                  [42.000000],

                  [43.000000],

                  [44.000000],

                  [45.000000],

                  [46.000000],

                  [47.000000],

                  [48.000000]

              FROM

              [D:\Users\kchawda\Downloads\Data 2015M11-Nov_RPT.xlsx]

              (ooxml, embedded labels, header is 1 lines, table is Sheet1, filters(

              Remove(Row, Pos(Top, 30)),

              Remove(Row, Pos(Top, 29))

              ));

               

              New:

              NoConcatenate

              LOAD Employee,

              floor(trim(WeekNumber1)) as WeekNumber,

              floor(trim(Hours1)) as Hours

              Resident Data;

               

              DROP Table Data;