Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
_armoco_
Partner - Creator II
Partner - Creator II

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
Specialist
Specialist

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

Mark_Little
Luminary
Luminary

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

Anonymous
Not applicable

Use This

_armoco_
Partner - Creator II
Partner - Creator II
Author

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

martinpohl
Partner - Master
Partner - Master

this is QlikView!

luismadriz
Specialist
Specialist

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