I read an interesting post this morning by Gregor Aisch entitled Doing the Line Charts Right.
One of the features that he mentions is about labeling the lines rather than having a legend. This is not a feature that we have natively in QlikView, but it is achievable.
The "default" option in QlikView is to have a legend in the line chart. The problem being that the user has to look to the legend then look back to the chart - which can cause difficultly, especially as the number of lines increases.
To change this, we can make use of the Value on Data Point option and using Dual in the expression.
Here is the expression that I am going to use:
If(MonthYear=Max(total MonthYear), CategoryType, ''),
Then I enable the Value on Data Point option (which you wouldn't normally apply to line charts). The value that will be displayed is the Text in the dual, not the number (also make sure that the number format is "Expression Default") which will be blank except for the last point. Then we end up with this:
Just what I was looking for.
Stephen Redmond is CTO of CapricornVentis a
QlikView Elite Partner
Follow me on Twitter: @stephencredmond