topic Line chart vs Pivot chart in QlikView

Line chart vs Pivot chart

Fri, 10 Sep 2010 10:13:10 GMT

I have created a pivot tabel wich has the correct calculations, but when transforming it in to a line chart the output is transformed (see screenshot). Why does not the line chart present the same values as the pivot table and how should I do to do so? The expression is the same in the pivotchart as in the line chart.

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/8030.Problem-Linje-graf.pptx:550:0]

Line chart vs Pivot chart

tresB — Fri, 10 Sep 2010 11:44:06 GMT

Can you upload your Application - sample ?

Regards,

tresesco

Line chart vs Pivot chart

Fri, 10 Sep 2010 12:15:32 GMT

Hi,

Use this data set (could not upload the qvw file) and use the two dimensions week, Brand with the following expression:

RangeAvg(Above(Count(Brand)),Count(Brand),Below(Count(Brand)))/RangeAvg(above(Count({<Brand=>}Total<Week> Week)),Count({<Brand=>}Total<Week> Week),below(Count({<Brand=>}Total<Week> Week)))

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/0285.Sample.xlsx:550:0]

Line chart vs Pivot chart

tresB — Fri, 10 Sep 2010 13:00:39 GMT

See, i am not getting any difference. Refer to the attached image.

If the issue still persist for you, i think its not because of chart presentation difference, but because of special behavior of Pivot table in case of duplicate data. Check that point, if your modelling creating multiple values against a single combination of dimensions.

Regards,

tresesco

Line chart vs Pivot chart

Fri, 10 Sep 2010 13:17:18 GMT

Nope,

it's easier to see the discrepancy if you place weeks on the x-axis.

Try to create the same as on sceenshot attached.

As you can see the levels do not match at all between the line and the column Annat.

Line chart vs Pivot chart

tresB — Fri, 10 Sep 2010 13:29:13 GMT

Still No difference !

Line chart vs Pivot chart

Fri, 10 Sep 2010 14:04:22 GMT

I see now! The result changes when drawing out brand to columns. Otherwise the calculation ends up wrong. The chart does not take that in to account and thus I need to find out how i shall construct the chart in order to match the pivot table where brands are in columns.