Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try flipping the order of your dimensions...? Promote the one listed second to the top of the list
Hi Katie,
Unfortunately I can't do this as the calc in the pivot table is based on reference to the column before:
1 - ((
rangesum(before(count(ID),0,NoOfColumns()))
/ count(TOTAL <[Payband]> ID)))