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: 
helen_pip
Creator III
Creator III

Target in a graph

Hello

I have built a chart and I have a dimension of MonthYear along the x axis and the graph shows the 95th centile using the following expression;

 

Fractile

(If( ADM = 'ADMITTED' , Total_Waits

),0.95)/1440

I would like to add a new line on the graph and show the target time, which is 4hours or 240.  My Axis is displayed in the same format as my expression

I.e. 04:00

I need to know where I write the target I.e. is it an expression or is it a reference line.  Also how would I write it so I get 04:00 across the entire graph?

Any ideas?

Thanks

Helen

1 Reply
mazacini
Creator III
Creator III

Hi Helen

Try this:  Create an expression called target, and simply hard type in the target value as the expression.

Rgds

Joe