I have a pivot table in Qlikview that is based on a calculated expression :
The pivot table looks like this:
| Band | 400k | 500k | 600k | 750k | 1m | 1.5m | 2m | 3m |
| 1.5 - 2 | 0.98 | 0.53 | 0.25 | 0.10 | 0.02 | 0.00 | 0.00 | 0.00 |
| 2 - 2.5 | 1.00 | 0.90 | 0.78 | 0.51 | 0.33 | 0.22 | 0.00 | 0.00 |
| 2.5 - 3 | 1.00 | 0.92 | 0.84 | 0.57 | 0.37 | 0.30 | 0.00 | 0.00 |
| 3 - 4 | 1.00 | 0.98 | 0.86 | 0.70 | 0.48 | 0.39 | 0.16 | 0.00 |
| 4 - 5 | 1.00 | 1.00 | 0.93 | 0.87 | 0.73 | 0.50 | 0.37 | 0.00 |
| 5 - 7.5 | 1.00 | 1.00 | 1.00 | 0.97 | 0.81 | 0.61 | 0.58 | 0.00 |
| 7.5 - 10 | 1.00 | 1.00 | 1.00 | 1.00 | 0.83 | 0.50 | 0.33 | 0.00 |
| 10+ | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 0.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
