topic Re: Bar chart above and below zero values in QlikView

Bar chart above and below zero values

Fri, 29 Aug 2014 01:06:27 GMT

Can anyone help me to create a bar chart that would show positive and negative values for a category in one bar (or at least make it appear like one bar) above and below the 0 axis? I'm trying to show gains and losses by category.

Above is a screen shot of what i want it to look like and I've attached a sample doc with data and the chart as close as i can get it.

Re: Bar chart above and below zero values

jagan — Fri, 29 Aug 2014 02:40:58 GMT

Hi,

Try like this

Dimension : ProductID

Expressions:

Enrolled : =Sum(Enrolled)

Cancelled: =Sum(Cancelled)*-1

Now Chart Properties-> Style-> Select subtype as Stacked

Hope this helps you.

Regards,

Jagan.

Re: Bar chart above and below zero values

Fri, 29 Aug 2014 02:53:55 GMT

See attached,

is this what you are trying, your requirement wasn't much clear.

Cheers

Re: Bar chart above and below zero values

Fri, 29 Aug 2014 13:16:33 GMT

Perfect! The 'stacked' property is what i was overlooking. Thanks!