Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Partner
Partner

Bar chart showing difference in sales between months

Hi,

How do I show the difference between sales value of previous and the next month in a bar chart? Capture.PNG

I need the difference in Apr and May, May and Jun, Jun and July and likewise for the remaining months in a bar graph.

Thanks and Regards,

Arjun

6 Replies
luismadriz
Valued Contributor

Re: Bar chart showing difference in sales between months

Hi,

I haven't seen that. Maybe with an extension?

The best thing I can think of is a stacked bar char with one bar being the Sum(Sales) and the other bar on top being fabs(Below(Sum(Sales)) - Sum(Sales))

Good luck,

Cheers,

Luis

Partner
Partner

Re: Bar chart showing difference in sales between months

Hi Arjun,

What exactly are you wanting to see? Do you want the bar chart with the change values shown?

or are you just wanting to see the change?

Have you looked at the waterfall chart?

Mark

asimansari2017
New Contributor III

Re: Bar chart showing difference in sales between months

Use This

Partner
Partner

Re: Bar chart showing difference in sales between months

Hi Mark,

The waterfall chart is having an option of just one measure. In this case I need months as Dimension, which I'm not able to use. I also tried out the extension and for some reason(maybe my ignorance!) it wont show negative bars when sales figure falls. See the image below,

Capture.PNG

The sales value falls for the month of June(See the first image I posted before). Here shouldn't the bar fall negative?

This is the reason that I resorted to the original bar graph, for which I couldn't think a way through.

Regards,

Arjun

Partner
Partner

Re: Bar chart showing difference in sales between months

this is QlikView!

luismadriz
Valued Contributor

Re: Bar chart showing difference in sales between months

Hi,

Just wondering to know how did you go,

Cheers

Luis

When applicable please mark the appropriate replies as Correct. This will help community members know which discussions have already been addressed and have a possible known solution. Please mark replies as Helpful if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as Helpful if you feel additional info is useful to others