Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

UI related Issue

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...

16 Replies
vijay_iitkgp
Partner - Specialist
Partner - Specialist

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.

Not applicable
Author

Hi Vijay,

        Really Thanks alot.. I dnt observe that.. BTW nice talking to you..

Not applicable
Author

Hi Vijay,

        Really Thanks alot.. I dnt observe that.. BTW nice talking to you..

vijay_iitkgp
Partner - Specialist
Partner - Specialist

Same here   

stephencredmond
Partner - Specialist II
Partner - Specialist II

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

vijay_iitkgp
Partner - Specialist
Partner - Specialist

Good one Stephen. It will really help to distinguish +ve and -ve numbers

Not applicable
Author

Hi,

   That is a good way of differentiating the +ve and -Ve values ..

Thanks for reply..