Limit in line chart

[Anonymous]

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

[StarinieriG]

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

[Anonymous]

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

[StarinieriG]

I mean like in the image (adding a measure), if it is a static number

[Anonymous]

I'm really sorry, but I'm confused. 😞

[Anil_Babu_Samineni · Accepted solution]

May be add reference line for 3.5 and change the color as per needs?

[Anonymous]

Ahhh! Thank you very much! 🙂 

The keyword reference line helped me! I wish you all a nice day! 🙂

[Anil_Babu_Samineni]

Great, Please mark as proper answer as accepted solution.