Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
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

Tags (2)
1 Solution

Accepted Solutions

Re: Funny Line Graph Results

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

8 Replies
MVP
MVP

Re: Funny Line Graph Results

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

Re: Funny Line Graph Results

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

Not applicable

Re: Funny Line Graph Results

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

Would be great if someone can help!

Re: Funny Line Graph Results

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

MVP
MVP

Re: Funny Line Graph Results

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

Not applicable

Re: Funny Line Graph Results

Thanks Sammy Sunny ()!

That was the problem.

Not applicable

Re: Funny Line Graph Results

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

Re: Funny Line Graph Results

No problem

Name is Sunny