Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
afaque19
Contributor
Contributor

Need help to add target line in Bar chart.

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.

Chart.JPG

Target for each brand varies as below :

BrandTarget
A9
B7
C8
D6


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


Thanks,

Afaque

5 Replies
Not applicable

load Target for each brand  as an inline load:

loadINLINE [
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

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
afaque19
Contributor
Contributor
Author

Hi Khushboo,

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

Chart_inline.JPG

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

Chart_Req.JPG

So any further guidance will be much appreciated.


Regards,

Afaque

afaque19
Contributor
Contributor
Author

Thanks for the reference link.

afaque19
Contributor
Contributor
Author

Any one out there Who can help me in this.