topic Re: Bar Chart with Multiple Reference Lines in QlikView

Bar Chart with Multiple Reference Lines

evansabres — Thu, 07 Sep 2017 14:23:31 GMT

I have a bar char in which the dimension is called 'nwEventDate' and an expression of =[Net Sold Qty]

For each nwEventDate, I have a target number for [Net Sold Qty]. In the chart, I want to create a reference indicator to show where each nwEventDate is in relation to the target [Net Sold Qty]

What is the most efficient way to do this?

Re: Bar Chart with Multiple Reference Lines

effinty2112 — Thu, 07 Sep 2017 14:49:07 GMT

Hi Evan,

Try a combo chart with the two expressions Sum([Net Sold Qty]) and Target. In the Expressions tab configure the first expression as Bar and the second as Symbol.

Cheers

Andrew

Re: Bar Chart with Multiple Reference Lines

evansabres — Thu, 07 Sep 2017 14:51:05 GMT

Andrew -

Thank you for the response. Each nwEventDate has a different target quantity [Net Sold Qty]

For example, 10/1/17 has a target of 18,000

but 10/2/17 has a target of 16,500

Would your solution still apply?

Re: Bar Chart with Multiple Reference Lines

Anil_Babu_Samineni — Thu, 07 Sep 2017 14:57:51 GMT

Yes