Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Not applicable

Bar chart above and below zero values

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.Plus Minus Bar.png

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.

Tags (2)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Bar chart above and below zero values

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.

3 Replies
MVP & Luminary
MVP & Luminary

Re: Bar chart above and below zero values

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.

Not applicable

Re: Bar chart above and below zero values

See attached,

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

Cheers

Highlighted
Not applicable

Re: Bar chart above and below zero values

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