Need help to add target line in Bar chart.

[afaque19]

Hi all,

Hope all of you are doing good. I am new to QlikView and I got a requirement  to plot a graph for Sales by product.

I need to add target line for the following chart.

Target for each brand varies as below :

Brand	Target
A	9
B	7
C	8
D	6

Please find the attached QlikView application.  Any suggestions will be much appreciated.

Thanks,

Afaque

[#2]

load Target for each brand  as an inline load:

load *  INLINE [
Brand,Target
A, 9
B ,7
C, 8
D, 6
];

use combo chart.

add another expression to chart as sum(target)

in display option for second expression unselect bar and select line.

Khushboo

[vikasmahajan]

See this link https://community.qlik.com/message/566974#566974

Vikas

[afaque19]

Hi Khushboo,

Thanks for the suggestion. But after applying your solution, I got this

But as per my requirement the chart should look like this (This chart is plotted in Excel)

So any further guidance will be much appreciated.

Regards,

Afaque

[afaque19]

Thanks for the reference link.

[afaque19]

Any one out there Who can help me in this.