Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Creating a graph

I have a pivot table in Qlikview that is based on a calculated expression :

The pivot table looks like this: 

Band400k500k600k750k1m1.5m2m3m
1.5 - 20.980.530.250.100.020.000.000.00
2 - 2.51.000.900.780.510.330.220.000.00
2.5 - 31.000.920.840.570.370.300.000.00
3 - 41.000.980.860.700.480.390.160.00
4 - 51.001.000.930.870.730.500.370.00
5 - 7.51.001.001.000.970.810.610.580.00
7.5 - 101.001.001.001.000.830.500.330.00
10+1.001.001.001.001.001.001.000.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

Tags (3)
2 Replies
Not applicable

Re: Creating a graph

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

Not applicable

Re: Creating a graph

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

Community Browser