3 Replies Latest reply: Aug 30, 2017 5:51 AM by Court van de Lisdonk RSS

    files belonging to earlier discussions

    Court van de Lisdonk

      Here is a Qlikview Document belonging to the discussions about totals in a Pivottable

       

      And Data from an Excel sheet

       

        

      Interval-999999-999999< -14 Tage< -14 Tage-14<=Tage<=-8-14<=Tage<=-8-7<=Tage<=-2-7<=Tage<=-2-1<=Tage<=+1-1<=Tage<=+1+2<=Tage<=+7+2<=Tage<=+7+8<=Tage<=+14+8<=Tage<=+14> +14 Tage> +14 Tage
      Booking monthTotal AmountSalesShare in %SalesShare in %SalesShare in %SalesShare in %SalesShare in %SalesShare in %SalesShare in %SalesShare in %
      Total 7450,0887%1.500.2144,9199%2.359.7947,6484%6.642.55021,4939%8.290.56826,8350%5.117.56016,5587%2.694.2788,7178%4.299.91113,9130%
      Jan 3.351.6702940,1261%119.3403,5606%154.3304,6046%709.79021,1772%728.40221,7325%550.97216,4387%422.40612,6028%666.13519,8747%
      Feb 3.905.435--148.1993,7947%291.5767,4659%809.39520,7248%931.35523,8477%550.35114,0919%362.6049,2846%811.95620,7904%
      Mrz 4.486.280--371.2858,3713%306.9446,9207%1.045.76023,3102%1.077.93924,0275%707.03015,7598%406.8039,0677%570.51912,7170%
      Apr 3.463.823220,0110%167.5574,9618%175.8825,0777%610.48517,6246%923.07026,6489%695.54120,0802%373.41410,7804%517.85214,9503%
      Mai 4.058.615--182.4214,7344%379.7249,3560%885.23421,8112%1.252.88130,9538%643.07415,8447%214.0135,2730%501.26912,3507%
      Jun 3.997.630--245.6616,1452%409.83210,2519%780.68219,5286%1.060.24426,5218%700.43817,5213%284.1937,1090%516.57912,9221%
      Jul 4.237.035--156.6453,7583%399.7919,4385%925.82321,8574%1.195.59928,2178%771.39818,2061%382.2599,0219%405.5189,5708%
      Aug 3.405.1324300,1046%109.1053,2041%241.7137,0985%875.38025,7077%1.121.07832,9232%498.75614,6472%248.5867,3003%310.0839,1063%
      MonthsAmountsPercentages
      Jan3.351.670100,1173%
      Feb3.905.435100,0000%
      Mrz4.486.280100,1742%
      Apr3.463.823100,1238%
      Mai4.058.615100,3239%
      Jun3.997.630100,0000%
      Jul4.237.035100,0708%
      Aug3.405.132100,0920%