topic Re: Percentage Display Format in QlikView

Percentage Display Format

rohitians — Mon, 24 Jun 2013 06:19:55 GMT

Hello,

I have two colums where in I have sales comparison for two years,

I am have grwth % column,

Everythin is fine but want to show negative growth in following format (20) format rather -20..

Thanks and Regards,

Rohit Yadav

Re: Percentage Display Format

rohitians — Mon, 24 Jun 2013 06:53:31 GMT

Hello,

I want to display -20 as (20)

Re: Percentage Display Format

narender123 — Mon, 24 Jun 2013 07:03:07 GMT

Hi Rohit

if you have a column with -tive field then you have to multiply your expression with (-1)

or if have have only -20 single field that you want it 20 the set expression as

if(field='-20',20,field)

Thanks.

Re: Percentage Display Format

Mon, 24 Jun 2013 07:04:52 GMT

try this function like this example

=fabs( -3.8 ) returns 3.8

example--

=fabs( -20 ) returns 20

Re: Percentage Display Format

Sokkorn — Mon, 24 Jun 2013 07:13:37 GMT

Hi,

Use Num() function will do this job.

=Num(-20,'#,##0;(#,##0)') ==> Return (20)

Now let give a try =Num(Field,'#,##0;(#,##0)') and let me know

Regards,

Sokkorn

Re: Percentage Display Format

rohitians — Mon, 24 Jun 2013 07:24:33 GMT

Hello ,

This is my current expression...

IF(Column(1)<0.001 OR Column(2)<0.001,NULL(),((Column(1)-column(2))/fabs(column(2)))*100)

The growth can either be positive or negative if its negative i wanna show -20 as (20)..

Thanks and Regards,

Rohit

Re: Percentage Display Format

Mon, 24 Jun 2013 07:31:02 GMT

try this

=IF(Column(1)<0.001 OR Column(2)<0.001,NULL(),'(' & (fabs((Column(1)-column(2))/fabs(column(2))) *100) & ')')

Re: Percentage Display Format

Sokkorn — Mon, 24 Jun 2013 07:34:14 GMT

Hi Rohit,

This should work

IF(Column(1)<0.001 OR Column(2)<0.001,NULL(),Num(((Column(1)-column(2))/fabs(column(2)))*100,'#,##0;(#,##0)'))

Regards,

Sokkorn