Creating a graph

Fri, 25 Oct 2013 16:01:59 GMT

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

Re: Creating a graph

Fri, 25 Oct 2013 16:05:36 GMT

try flipping the order of your dimensions...? Promote the one listed second to the top of the list

Re: Creating a graph

Fri, 25 Oct 2013 16:10:56 GMT

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)))

topic Re: Creating a graph in QlikView

Creating a graph

Re: Creating a graph

Re: Creating a graph