topic Re: Conditional Show Value on Each Line on a Line Chart? in QlikView

Conditional Show Value on Each Line on a Line Chart?

dena_reavis — Thu, 11 May 2017 15:27:04 GMT

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.

Re: Conditional Show Value on Each Line on a Line Chart?

sunny_talwar — Thu, 11 May 2017 15:36:02 GMT

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

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

Re: Conditional Show Value on Each Line on a Line Chart?

Sergey_Shuklin — Thu, 11 May 2017 15:49:24 GMT

Hello, Dena!

Please, look at the attachement.

Re: Conditional Show Value on Each Line on a Line Chart?

dena_reavis — Thu, 11 May 2017 16:55:17 GMT

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.

Re: Conditional Show Value on Each Line on a Line Chart?

Sergey_Shuklin — Thu, 11 May 2017 17:34:18 GMT

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.

Re: Conditional Show Value on Each Line on a Line Chart?

dena_reavis — Thu, 11 May 2017 18:18:30 GMT

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

Thank you both very very much!!

Re: Conditional Show Value on Each Line on a Line Chart?

dena_reavis — Thu, 11 May 2017 19:13:08 GMT

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!!

Re: Conditional Show Value on Each Line on a Line Chart?

sunny_talwar — Thu, 11 May 2017 19:17:50 GMT

See if this link helps:

How to avoid overlap values in a Timeline?