This content has been marked as final. Show 2 replies
I have a pivot table in Qlikview that is based on a calculated expression :
The pivot table looks like this:
|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|
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.