Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Funny Line Graph Results

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

Line Graph.PNG

1 Solution

Accepted Solutions
sunny_talwar

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)

Capture.PNG

View solution in original post

8 Replies
tresesco
MVP
MVP

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

sunny_talwar

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

Not applicable
Author

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

Would be great if someone can help!

sunny_talwar

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)

Capture.PNG

tresesco
MVP
MVP

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

Not applicable
Author

Thanks Sammy Sunny ()!

That was the problem.

Not applicable
Author

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

sunny_talwar

No problem

Name is Sunny