Conditional Show Value on Each Line on a Line Chart?

[dena_reavis]

Dear QlikView Experts,

I have been trying to get the last value as the label on each line of a line chart, and I just can't get it to work.

I saw examples in this post and this one and this one and I just can't get this to work. I am attaching an example QVW I created. Hopefully someone can spot what I am doing wrong.

I made sure on the second expression for the Description, I unchecked the 'Values on Data Points'. However, I tried a bunch of different things suggested in the posts on the subject, and I just don't have it right.

Please help! Thank you very much.

[sunny_talwar · Accepted solution]

How about using this as your expression and enabling 'Values on Data Points'

If(PayPeriodNumber=max(total PayPeriodNumber), VolumeDesc, ' ')

[Sergey_Shuklin]

Hello, Dena!

Please, look at the attachement.

[dena_reavis]

Thank you Sergey, but is there a way I can do this without explicitly naming the "Apples" and "Oranges" in each? I will have an ever-changing set of "fruits" in my real data.

[Sergey_Shuklin]

In that case Sunny's decision will suit better, but using it you will lose a dots at the end of lines.

So it's a matter of priotities - usability or visual.

[dena_reavis]

You are both right! It turns out I got Sunny's suggestion to work as well!

Thank  you both very very much!!

[dena_reavis]

Just out of curiosity, is there anything I can do to keep the labels from overlapping? I've looked at the Axis options but - here's a real challenge - how could I dynamically calculate the Static Steps to fix the data selected? I was thinking something like the max of the total data minus the min of the total data divided by the number of the items displayed of the dimensions (Apples, Oranges, all other possible fruits, etc.).

Attached picture is example of the labels overlapping each other.

Thank you very much!!

[sunny_talwar]

See if this link helps:

How to avoid overlap values in a Timeline?