12 Replies Latest reply: Sep 26, 2011 2:04 PM by carl lachmann RSS

    Line graph, using column average as points on the line

      Hi,

       

      In Excel, I use a line graph. The data (in excel) is;

       

      TypeAspect 1Aspect 2Aspect 3Aspect 4Aspect 5Aspect 6
      blue652533
      green765555
      yellow766567
      green765767
      blue654644
      yellow777777
      green656455
      blue442422
      blue765754
      yellow766666
      green667667
      green765657
      blue433332
      blue667777

       

       

      From the data I use the formula in excel "averageif" to make the next table;

      TypeAspect 1Aspect 2Aspect 3Aspect 4Aspect 5Aspect 6
      blue5,504,833,835,334,003,67
      green6,605,805,605,605,406,20
      yellow7,006,336,336,006,336,67

       

       

      An from this I can plot a diagram, like the one below;

       

       

      It would be ever so nifty if I could do this using Qlikview, but I have not been able to find out how to get the x-axis values be those of the column headings. I am guessing the it should be relatively easy, but being a newbie, it all seems kinda tricky...