topic Re: How to diplsy negative values in brackets in QlikView

How to diplsy negative values in brackets

Tue, 23 Apr 2013 06:30:53 GMT

Hi,

How to diplsy negative values in brackets

(+356) this formate and negative values 456 this formate in the result (356)

456 like this only any condition for this

plz help me.

Thanks,

Re: How to diplsy negative values in brackets

Tue, 23 Apr 2013 07:18:11 GMT

On the Number tab of the properties screen select your expression and check Fixed to under Number Format Settings. Set the format pattern to#.##0,00; (#.##0,00)

Re: How to diplsy negative values in brackets

Tue, 23 Apr 2013 08:23:55 GMT

Dear damodark

by using fabs we can convrt nagative to possite

apr sales=- 7000

sum(fabs(apr sales)) it convert to nagative to possitive

Re: How to diplsy negative values in brackets

jagan — Tue, 23 Apr 2013 08:40:03 GMT

Hi Damodar,

Check this URL

http://community.qlik.com/message/290148#290148

Hope this helps you.

Regards,

Jagan.

Re: How to diplsy negative values in brackets

Tue, 23 Apr 2013 08:40:49 GMT

In the "Number" tab of your chart properties select your expression. Then select "Integer" from the "Number Format Settings" and in "Format Pattern" add the following (+#,##0); (#,##0)

Hope this helps.