2 Replies Latest reply: Oct 25, 2013 12:10 PM by Joe Berry RSS

    Creating a graph

      I have a pivot table in Qlikview that is based on a calculated expression :


      The pivot table looks like this: 


      1.5 - 20.980.530.
      2 -
      2.5 - 31.000.920.840.570.370.300.000.00
      3 - 41.000.980.860.700.480.390.160.00
      4 -
      5 -
      7.5 -


      What I want is a graph that looks like the attached (Capture), which excel creates at the first attempt. Instead, I get a graph that looks ridiculous and isnt based on the values in the pivot table (see Capture2).


      For a start, it places the Banding along the x-axis. Secondly, why is it in a straight line and not plotting the values in the table?


      Any help over the weekend would be greatly appreciated.