Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Adding data labels to just last point on time series graph

Is there an easy way to add the value of the right-most point of a time-series graph? This would make it easy to identify what the value is exactly.I don't want every point on the graph labeled, though.

The expression for my trend graph looks like this:

=

rangesum(above(sum([Member Count]),0,12))

/

rangesum(above(sum([Member Count]),12,12))

-1

Dimension is Month.

1 Solution

Accepted Solutions
stephen-a_redmo
Valued Contributor II

Re: Adding data labels to just last point on time series graph

Hi,

Have a look at the attached example.

Regards,

Stephen

10 Replies
stephen-a_redmo
Valued Contributor II

Adding data labels to just last point on time series graph

Dual might work.

Something like:

dual(if(Dim1=[last value in dimension], 'Label i want', ''), Count(Dim1))

Regards,

Stephen

Not applicable

Re: Adding data labels to just last point on time series graph

I don't think the Dual function is what I'm looking for. Attached is a mock-up of what it would look like.

stephen-a_redmo
Valued Contributor II

Re: Adding data labels to just last point on time series graph

Hi,

Have a look at the attached example.

Regards,

Stephen

Not applicable

Re: Adding data labels to just last point on time series graph

Thanks for the example. I've tried using your expression

Dual(

if(Month='$(=Max(Month))', Num(Avg(Perc), '0.0%'), ''),

Avg(Perc))

and replacing "Ave(Perc)" with my function, but had no luck.

stephen-a_redmo
Valued Contributor II

Re: Adding data labels to just last point on time series graph

Hi,

It is not really to do with luck.

Make sure that you have no format (expression default) specified in the number tab.  you have "Value on data point" specified.

Of course, I have no clue as to what is the problem because I don't have your data and "I had no luck" isn't really a great problem description.

Regards,

Stephen

Not applicable

Re: Adding data labels to just last point on time series graph

Stephen, your advice has certainly increased my luck. I can now get the value of the final point to be displayed at the bottom of the graph, at least. I did this by also checking "Text on Axis" as a Display Option on the Expressions tab.When I uncheck this box, the value disappears. I appreciate your help on this problem.

stephen-a_redmo
Valued Contributor II

Adding data labels to just last point on time series graph

Hi,

If you copy my chart into your document and modify the dimension and expression, does it work?

Do you have multiple dimensions or multiple expressions to achieve the 3 lines?

Regards,

Stephen

Not applicable

Adding data labels to just last point on time series graph

If I copy your example it works! Now I just need to figure what was different for me. Thanks again!

Not applicable

Re: Adding data labels to just last point on time series graph

The problem is occuring when I add more than one expression to the graph. It can't seem to handle more than 1. When there are 2, they both work when only one is enabled. But, when both are enabled, the % disappears. The trend line still shows.

Community Browser