Target in a graph

helen_pip — Wed, 13 Feb 2013 12:10:13 GMT

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

Re: Target in a graph

mazacini — Wed, 13 Feb 2013 21:21:19 GMT

Hi Helen

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

Rgds

Joe

topic Target in a graph in QlikView

Target in a graph

Re: Target in a graph