Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
See this link https://community.qlik.com/message/566974#566974
Vikas
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
Thanks for the reference link.
Any one out there Who can help me in this.