7 Replies Latest reply: Apr 10, 2013 3:42 PM by Frank Hartmann RSS

    3 dimensional chart

    Frank Hartmann

      hi guys,

       

      i´m a newbie on qlikview and i need your help

       

      for example if i have a excel file  with rawdata. the fields are:

       

       

      idcountryused_function#clicks
      01germanywrite5
      02spainwrite4
      03italyread9
      04usawrite8
      05germanyread6
      06portugalread3
      07italywrite11
      08usaread15
      09franceread12
      10germanywrite4
      11spainread19
      12usawrite15
      13francewrite2
      14spainread6
      15germanyread9

       

      but there are alot more values in the tables. now i want to make a 3d bar chart with countries on the x-axis, sum of  #clicks in the four intervals; x<5, x>=5 and <10, x>=10 and <15, x>=15 on the y-axis and the intervals itself as the z-axis.

       

      sould look like this:

       

      1.png

       

      but if i try to rebuild the excelchart in qlikview it looks like this:

       

      2.png

       

       

      so my problem is that the rows are only duplicated. but for example i need the yellow bar in front position the blue bar in second position the green in third position

      and the red one in last position and not stacked!!

       

      hope you understand my problem and can help me!!!