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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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