Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

laurencepurcell
New Contributor II

Adding Differences between Bars in a Bar Chart

Hi,

I have a bar chart detailing figures per month in Qlik Sense. I would like to add a figure between the adjacent bars that tells me what the difference between the two figures is. Similarly, if I select two bars across the chart it will change to show the difference between those figures.

Is this possible? Or is there a different way to show the progression between bars (not a waterfall diagram)?

Many Thanks,

L

4 Replies
agigliotti
Honored Contributor II

Re: Adding Differences between Bars in a Bar Chart

you could use an expression like below:

column(1) - above(column(1))

where 1 means the first measure

I hope this helps.

laurencepurcell
New Contributor II

Re: Adding Differences between Bars in a Bar Chart

Hi Andrea,

Thanks for your reply. That's a really good way to show it with another bar.

Do you know if it's possible to for example have lines between the bars with the figure showing or any similar ways?

E.g.

Thanks!

agigliotti
Honored Contributor II

Re: Adding Differences between Bars in a Bar Chart

As I know you can't with native obejcts.

Anyway you can take a look for some extensions on Branch here Qlik Branch

undergrinder
Valued Contributor II

Re: Adding Differences between Bars in a Bar Chart

Hi Laurence,

if want to show that differences, I suggest you to use waterfall chart.

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Visualizations/WaterfallChart/wate...

G.

Community Browser