Line reference on stacked bar graph

[#1]

Hi everyone,

I really hope you can help me, basically I have a stacked bar and I want to show a reference line (it has to be a line) per each dimension value as I'm showing in the graph but still can't figure out how. Qlik can do this very easy but not with lines. I'm attaching the qvw of how it works naturally with Qlik and how I want it. If I can't do it naturally in Qlik, do you guys have any recommendations? an extension maybe?

Thank you very much

[amit_saini]

Hi,

Try

Thanks,

AS

[jonathandienst]

Reference lines apply to the whole chart rather than a single dimension value. You might be better off using a symbol plot for the revenue (convert to combo chart if necessary), or add another bar to the stack to get to the revenue number (revenue less the sum of the costs). You could make the bar very distinctive to distinguish between cost and profit.

[HirisH_V7]

Hi,

You can use trend lines,

1. For creating a ready and Calculated Values ,

1. By selecting them you can get what you desired Line passing your Bars.

Else,

• If you have Revenue field you can go with Values list and Create a expression for revenue and use it in Bar Chart.

HTH,

Hirish

[luciancotea · Accepted solution]

Hi Viridiana,

I think this would do it:

See attachment.

[#6]

Perfect!!! Thank you very much

[#7]

Thank you Amit, I tried this before but as Jonathan said "reference lines apply to the whole chart rather than a single dimension value". I think I got the solution I needed but I really appreciate you took the time to reply 😃 Thanks