topic Re: Bar Chart negative values in QlikView

Bar Chart negative values

Thu, 01 Aug 2013 14:26:32 GMT

Hi All,

I have a requirment ... i need to shown budget, revenue and variance in a bar chart.

Variance will be negative always .... see below image

but my client wants to see variance bar on the postive values side of bar chart . But the values on data points should be negative number . See image below

To be simple my requirment is the variance value (i.e 5) in the second chart should be negative number. Is it possible ?

Please find attached qvw

Re: Bar Chart negative values

jerem1234 — Thu, 01 Aug 2013 15:45:46 GMT

Not sure if it is possible, maybe someone else has something. But a possible remedy might be just creating a text box with expression =sum(Revenue) - sum(Budget)

and then placing it where the 5 is on your second chart, then just uncheck values on data points on your chart for Variance.

The downside is that it is a second object and if your bar chart resizes or moves around, the placement of the textbox will be wrong.

You would also have to make sure your text box is on top layer. You would have to change your text pop-ups accordingly (since it would display the variance as being 5) by maybe unchecking text as pop-up for Variance or by creating a new expression just for a text pop-up.

Re: Bar Chart negative values

Gysbert_Wassenaar — Thu, 01 Aug 2013 17:21:27 GMT

You can use the dual function to add a display value to the result value. See attached qvw

Re: Bar Chart negative values

Fri, 02 Aug 2013 14:39:09 GMT

Hi Gysbert,

Thanks for your reply. I need to show that in money format rounded to two decimals( i.e as $-5.00) .

Can i use num infront of dual function ? I tried but not working

Re: Bar Chart negative values

Gysbert_Wassenaar — Fri, 02 Aug 2013 14:53:31 GMT

Works for me: =num(dual(Column(2) -Column(1),Column(1) -Column(2)),'$ #.00')

Or you can simply change the Number Format setting for the expression on the Number tab to Money and adjust the format string to your needs.

Re: Bar Chart negative values

Fri, 02 Aug 2013 15:01:27 GMT

Hi Gysbert

when i use your expression =num(dual(Column(2) -Column(1),Column(1) -Column(2)),'$ #.00')

the values on data points which are supposed to be negative are turning postive .

Can you attach the qvw for me ?

Re: Bar Chart negative values

Fri, 02 Aug 2013 15:02:26 GMT

Hai Srinu,

Try to this setup chart Properties-> Axes Tab ->Scale

This is helps for you.

Regards,

Senthil

Re: Bar Chart negative values

Gysbert_Wassenaar — Fri, 02 Aug 2013 16:20:39 GMT

Ah, right. The num function just changes the formatting, same as the dual function. Try this instead: =num(Column(1) -Column(2),'$-#.00')

Re: Bar Chart negative values

Fri, 02 Aug 2013 17:57:59 GMT

Thanks ... That worked for me