topic Re: Line reference on stacked bar graph in QlikView

Line reference on stacked bar graph

Tue, 23 Feb 2016 01:31:08 GMT

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

Re: Line reference on stacked bar graph

amit_saini — Tue, 23 Feb 2016 07:57:02 GMT

Hi,

Try

Thanks,

Re: Line reference on stacked bar graph

jonathandienst — Tue, 23 Feb 2016 08:36:21 GMT

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.

Re: Line reference on stacked bar graph

HirisH_V7 — Tue, 23 Feb 2016 13:51:52 GMT

Hi,

You can use trend lines,

For creating a ready and Calculated Values ,

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

Re: Line reference on stacked bar graph

luciancotea — Tue, 23 Feb 2016 14:30:52 GMT

Hi Viridiana,

I think this would do it:

See attachment.

Re: Line reference on stacked bar graph

Tue, 23 Feb 2016 15:59:00 GMT

Perfect!!! Thank you very much

Re: Line reference on stacked bar graph

Tue, 23 Feb 2016 16:12:42 GMT

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