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: 

       

      Band400k500k600k750k1m1.5m2m3m
      1.5 - 20.980.530.250.100.020.000.000.00
      2 - 2.51.000.900.780.510.330.220.000.00
      2.5 - 31.000.920.840.570.370.300.000.00
      3 - 41.000.980.860.700.480.390.160.00
      4 - 51.001.000.930.870.730.500.370.00
      5 - 7.51.001.001.000.970.810.610.580.00
      7.5 - 101.001.001.001.000.830.500.330.00
      10+1.001.001.001.001.001.001.000.00

       

      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.

       

      Thanks,

       

      Joe