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.
