Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello qlikers 🙂 ,
I had load data from a excel file in a line chart.
Now I want to add a limit. For example the limit should be y = 3.5 . See the red line below.
How can I do this?
Thank you in advance! 🙂
May be add reference line for 3.5 and change the color as per needs?
Hi,
what do you mean for "add a limit"? Limit y-axis? In that case, go to: Appearance > Y-axis > Range > Custom
If you want to add a simple line, you could use number 3.5 as expression
Sorry, for the not clear question. The Limit should be the red line. It is not a limit, it is only a line in the graph.
The second sentences is a good advice, but I actually don't know how can I get this expression over all dates or how I should build this expression.
Thank you in advance! 🙂
I mean like in the image (adding a measure), if it is a static number
I'm really sorry, but I'm confused. 😞
May be add reference line for 3.5 and change the color as per needs?
Ahhh! Thank you very much! 🙂
The keyword reference line helped me! I wish you all a nice day! 🙂
Great, Please mark as proper answer as accepted solution.