Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a bar chart in which I have plotted positive and Negative values.. Below are my requirements
1.I need to show the positive values enclosed in () i.e the display should be ($1000)
2.In the same way I need to show negative values enclosed in {} i.e {$1000)
3.By default Qlikview will show the negative values in the below axis.Is there any way that I can show the negative values above the Axis..
Awaiting for the reply..
Thanks in advance...
Please do not check money format in number tab.Go for only expression default in number tab. I am using Personal edition of QV so I cant send you apps.
Hi Vijay,
Really Thanks alot.. I dnt observe that.. BTW nice talking to you..
Hi Vijay,
Really Thanks alot.. I dnt observe that.. BTW nice talking to you..
Same here
Hi,
You might consider using a different colour for the negative bars also.
Click the "+" beside the expression in the properties and you will see a number of options. Click on "Background" and you can now define an expression to calculate the background colour - which will be the colour of the bar.
Regards,
Stephen
Good one Stephen. It will really help to distinguish +ve and -ve numbers
Hi,
That is a good way of differentiating the +ve and -Ve values ..
Thanks for reply..