Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

How to customize reference line

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.  

Tags (2)
1 Solution

Accepted Solutions

Re: How to customize reference line

Hi

Use like this,

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

Hope it helps

10 Replies

Re: How to customize reference line

Hi

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

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

Not applicable

Re: How to customize reference line

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

Hi

I think Its not possible..

Not applicable

Re: How to customize reference line

Is this possible to draw a line with expression?

Re: How to customize reference line

Hi

Try like this

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

if(NtWeeks > 0, 31.9)

Hope it helps

Not applicable

Re: How to customize reference line

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

Hi

     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..

Not applicable

Re: How to customize reference line

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

Hi

Use like this,

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

Hope it helps

Community Browser