topic Re: How to customize reference line in QlikView

How to customize reference line

Thu, 20 Sep 2012 18:19:20 GMT

Hi Experts,

I wanted to draw two reference lines for two set of data and would like to know whether I can change reference line's width, location in order to line reference line to different data.

Please see my screen shot.

Re: How to customize reference line

MayilVahanan — Thu, 20 Sep 2012 18:31:01 GMT

Do you want something like attached file.. If so,

Use weight, color and style in Add reference option in presentation tab in chart properties

Re: How to customize reference line

Thu, 20 Sep 2012 18:34:59 GMT

Actually I want the upper reference line for the second data set(right), and lower reference line for the first data set. The upper reference line should be cover 1-5, the lower reference line should cover -11 to -1. Is this possible? Thanks

Re: How to customize reference line

MayilVahanan — Thu, 20 Sep 2012 18:47:46 GMT

I think Its not possible..

Re: How to customize reference line

Thu, 20 Sep 2012 18:49:20 GMT

Is this possible to draw a line with expression?

Re: How to customize reference line

MayilVahanan — Thu, 20 Sep 2012 19:10:43 GMT

Try like this

if(INtWeeks <= -1, 46.9), instead of numbers ,you use your exp

if(NtWeeks > 0, 31.9)

Hope it helps

Re: How to customize reference line

Thu, 20 Sep 2012 19:24:29 GMT

It works perfectly. Is there any way to add a label to the these two lines? This is the last step. Thanks

Re: How to customize reference line

MayilVahanan — Thu, 20 Sep 2012 19:32:24 GMT

Use add "text chart" in presentation tab.. and with help of ctrl+shift, you can move and place it.. when chart change, its the value correctly but place in that same place..

Re: How to customize reference line

Thu, 20 Sep 2012 19:40:49 GMT

If the 'chart text' can stay with the line, that will be great.

I just tried enabling 'show value' property of expression, but it shows all the values at each data point even enough they are the same. If I can show only one value, that will solve my problem.

Thank you again.

Re: How to customize reference line

MayilVahanan — Thu, 20 Sep 2012 20:30:17 GMT

Use like this,

Expression-> click '+' sign, show value -> if(IntWeeks = -11, 1,0)

Hope it helps

Re: How to customize reference line

Thu, 20 Sep 2012 21:02:34 GMT

You are genius!!! All my problem solved! Thanks. Thanks! Thanks!