topic Re: How to add a hor line on my 8020 chart ? in QlikView

How to add a hor line on my 8020 chart ?

Wed, 11 Dec 2013 00:33:27 GMT

Hi All

I need to draw a horz line on my 8020 chart. any idea ? like the green line i add manually

Paul

Wed, 11 Dec 2013 00:35:34 GMT

See attached. You should use the trendline.

Wed, 11 Dec 2013 01:04:09 GMT

Hi Sir

you line 20% work for the chart , but if i change my dim to segment , the % vari. How to fix it ?

Paul

Sokkorn — Wed, 11 Dec 2013 02:03:37 GMT

Hi Mr Paul,

I would suggest you to change some setting for easy manage reference line. Like this

1. Go to Axes tab and select expression then change position

a. [Inclusive Percentage] -> Position = Left

b. [Sales] -> Position = Right

2. Go to Presentation tab and add "Reference Lines"

See sample attached file also.

Regards,

Sokkorn

Wed, 11 Dec 2013 02:20:14 GMT

very perfect ans.