1 Reply Latest reply: Oct 28, 2014 5:13 AM by Fra Car RSS

    DAYS OVER YEARS PIVOT AVERAGE

      WEEKDAY/ YEAR

      Y12

      Y13

      mon

      USD     7.834

      USD     2.393

      tue

      USD   19.831

      USD     4.724

      wed

      USD   14.120

      USD   17.222

      thu

      USD     4.026

      USD   19.265

      fri

      USD     8.423

      USD     7.196

      sat

      USD     9.694

      USD   17.589

      sun

      USD   19.608

      USD   12.448

      AVG

      USD 11.934

      USD 11.548

       

      i have the above data-set in a qlik pivot table. daily values are calculated with "sum()/count()" method; now i'd like to divide each daily value, each row, for the global yearly average (i.e. 11934 for year 2012 or first column last row). can i do that? if yes, how?!?

      below my desired result (a sort of coefficient, pure numbers):

       

      WEEKDAY/ YEAR

      Y12

      Y13

      mon

      0,66

      0,21

      tue

      1,66

      0,41

      wed

      1,18

      1,49

      thu

      0,34

      1,67

      fri

      0,71

      0,62

      sdt

      0,81

      1,52

      sun

      1,64

      1,08