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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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..