UI related Issue

[#1]

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

[vijay_iitkgp]

Hi,

If you are using chart or Pivot then go to Properties---->Number and check money radio button and change the format to

($#,##0.00);{$#,##0.00} . if u are using text box then use Num(Value,'($#,##0.00);{$#,##0.00}')

[#3]

Hi,

  Is there any option in the Qlikview where I could declare all the positive values should be enclosed between () and negative values between {} ..

Thanks in advance..

[vijay_iitkgp]

Yeah

You can do it in Script and Set : at main page

SET MoneyFormat='($#,##0.00);{$#,##0.00}';

Hope this will Help.

[#5]

Hi,

  The positive and negative results are coming up in my chart expressions based on that I need to enclose the same in the () or {} ..How do I classify the values in  declaring the MoneyFormat..???

[#6]

Hi All,

Can some one help me on this.. It is bit urgent...

Thanks in advance ..

[vijay_iitkgp]

Hi,

You can use

=If(Sum([Amount])>=0,Num(Sum([Amount]),'($##,#.0)'),Num(Sum([Amount])*-1,'{$##,#.0}'))

Regards

Vijay

[#8]

Hi VIjay,

         Thanks for the quick response.. The chart show all the values enclosed between ( ) .. If possible can u plz attach some sample QVWfor the same..

Thanks

[vijay_iitkgp · Accepted solution]

Hi ,

Please find the screenshots of expression and chart for your help.

[#10]

Hi Vijay,

         I really dnt know the reason why it is not coming at my end.. If you dnt mind can u plz attach the file with some sample data...