topic Re: How to create the red boundary line in bar chart in QlikView

How to create the red boundary line in bar chart

ananyaghosh — Thu, 25 Jun 2015 08:11:08 GMT

How to create the red boundary line in bar chart like the attached image? Actually my client want me to show it as target line. But I cannot understand , how to do it. Please help me about it.

Re: How to create the red boundary line in bar chart

alexandros17 — Thu, 25 Jun 2015 08:14:01 GMT

In presentatin tab there is a Reference line box, add your expression there.

Re: How to create the red boundary line in bar chart

jsingh71 — Thu, 25 Jun 2015 08:21:18 GMT

Hello Sandip,

To add reference line in your chart, follow this:

Chart properties--> Presentation Tab--> Click on Add button. See below image:

Re: How to create the red boundary line in bar chart

awhitfield — Thu, 25 Jun 2015 09:32:23 GMT

HI Sandip,

that looks like a reference line. You can create one on the Presentation Tab of you chart.

Click ADD, select the required values, Color, expression etc

and you get:

HTH - Andy

Re: How to create the red boundary line in bar chart

pavendhan — Thu, 25 Jun 2015 09:56:28 GMT

Presentation tab -> Go to Reference lines --> Add Default or calculated vale in Expression

Re: How to create the red boundary line in bar chart

Thu, 25 Jun 2015 10:03:23 GMT

HI sandip

Andy replied with clear picture of how to do it. Just follow his steps I think it's enough for your query

Re: How to create the red boundary line in bar chart

Thu, 25 Jun 2015 10:38:32 GMT

Do as per the instructions given by andy.

Re: How to create the red boundary line in bar chart

Thu, 25 Jun 2015 11:12:44 GMT

in expressions tab there is trend lines option. if you select there average then line will get in the chart

thanks and regards

Rasool

Re: How to create the red boundary line in bar chart

pratap6699 — Thu, 25 Jun 2015 13:20:29 GMT

Presentation tab -> Go to Reference lines --> Add -->give any value based on your refernce line -->60