topic UI related Issue in QlikView

UI related Issue

Mon, 23 Jan 2012 07:46:51 GMT

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

UI related Issue

vijay_iitkgp — Mon, 23 Jan 2012 08:37:24 GMT

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}')

UI related Issue

Mon, 23 Jan 2012 09:24:32 GMT

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

UI related Issue

vijay_iitkgp — Mon, 23 Jan 2012 09:30:20 GMT

Yeah

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

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

Hope this will Help.

UI related Issue

Mon, 23 Jan 2012 09:52:19 GMT

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

Re: UI related Issue

Mon, 23 Jan 2012 12:04:41 GMT

Hi All,

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

Thanks in advance ..

UI related Issue

vijay_iitkgp — Mon, 23 Jan 2012 13:26:37 GMT

Hi,

You can use

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

Regards

Vijay

Re: UI related Issue

Mon, 23 Jan 2012 14:00:30 GMT

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

Re: UI related Issue

vijay_iitkgp — Tue, 24 Jan 2012 08:11:05 GMT

Hi ,

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

Re: UI related Issue

Tue, 24 Jan 2012 09:09:16 GMT

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

UI related Issue

vijay_iitkgp — Tue, 24 Jan 2012 09:13:46 GMT

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.

Re: UI related Issue

Tue, 24 Jan 2012 09:17:29 GMT

Hi Vijay,

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

Re: UI related Issue

Tue, 24 Jan 2012 09:17:42 GMT

Hi Vijay,

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

UI related Issue

vijay_iitkgp — Tue, 24 Jan 2012 09:21:58 GMT

Same here

UI related Issue

stephencredmond — Tue, 24 Jan 2012 09:41:47 GMT

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

UI related Issue

vijay_iitkgp — Tue, 24 Jan 2012 10:03:08 GMT

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

Re: UI related Issue

Tue, 24 Jan 2012 10:37:20 GMT

Hi,

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

Thanks for reply..