topic Re: Funny Line Graph Results in QlikView

Funny Line Graph Results

Fri, 26 Aug 2016 07:06:45 GMT

Hi i am trying to plot a line graph for two different vendors and how there unit prices for the same part varied over time. However, when the unit price is the same, the data points are plotted on the same date on the graph, thus showing incorrect interpretation of the pivot table data.

I inserted this screen shot with highlighted figures to better explain what the problem is. The highlighted dates on the pivot table are missing from the line graph.

Does someone know what this is happening?

Thanks

Re: Funny Line Graph Results

tresB — Fri, 26 Aug 2016 07:31:04 GMT

I suggest to share a demonstrative sample. Have a look here: Preparing examples for Upload - Reduction and Data Scrambling

Re: Funny Line Graph Results

sunny_talwar — Fri, 26 Aug 2016 08:57:50 GMT

I guess what is the expression that you are using in your chart?

Re: Funny Line Graph Results

Fri, 26 Aug 2016 09:32:44 GMT

Thanks Amit for that great post. I can now attach my QVW ! !

Would be great if someone can help!

Re: Funny Line Graph Results

sunny_talwar — Fri, 26 Aug 2016 09:38:03 GMT

I think you need to fix your first dimension here.

You currently have

=Aggr(Max(Date([PO Date])), UnitPrice)

and need to change it to

=Aggr(Max(Date([PO Date])), VendorID, PartID, UnitPrice)

Re: Funny Line Graph Results

tresB — Fri, 26 Aug 2016 09:46:03 GMT

This is because you calculated the max date aggregating against the Unit Price. What is expected output?

Re: Funny Line Graph Results

Fri, 26 Aug 2016 09:56:08 GMT

Thanks Sammy Sunny ()!

That was the problem.

Re: Funny Line Graph Results

Fri, 26 Aug 2016 09:56:57 GMT

Your are right Amit. The aggr function was incorrect and is now working perfectly fine.

Re: Funny Line Graph Results

sunny_talwar — Fri, 26 Aug 2016 09:57:08 GMT

No problem

Name is Sunny