Line chart vs Pivot chart

[#1]

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]

[tresesco]

Can you upload your Application - sample ?

Regards,

tresesco

[#3]

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]

[tresesco]

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

[#5]

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.

[tresesco]

Still No difference !

[#7]

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.