Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Make a diagonal, linear reference line for accumulated values

Hi!

For each of the countries we deliver to, we have set total estimated sales (TES) for this year. Like this:

Country     Total estimated sales in 2017

X               12.000.000

We have a bar chart in which we show the accumulated monthly sales for this year. To show if the accumulated monthly sales meet the accumulated monthly ESTIMATED sales I would like to add a linear (diagonal) reference line which shows the accumulated estimed monthly sales ((TES/12)*month number).

I would like to this without adding a measure to my chart and just make use of the reference line function.

Any ideas to solve this are much appreciated!

Regards,

Hugo

1 Reply
tajmohamed30
Creator III
Creator III

On chart properties>Presentation>right bottom>under reference lines you can add it