Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
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.

View solution in original post

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.

View solution in original post

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

Not applicable

Re: Bar chart above and below zero values

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