topic Re: Negative to positive values in QlikView

Negative to positive values

krishna20 — Mon, 29 Dec 2014 08:37:00 GMT

Hi Friends,

I need to show the values from negative to positive with comma separated.

i used two ways to achieve this.

1. =if(YourExpression<0,chr(91)&fabs(YourExpression)&chr(93),YourExpression)

Result : Getting in square brackets.But, the value of one expression is not adding to another one.The another expression is showing as null.

E.g;

Paid:

=if(A<0,chr(91)&fabs(A)&chr(93),A)

O/P [23456]

premium:

=if(Paid+insured<0,chr(91)&fabs(Paid+insured)&chr(93),Paid+insured)

O/P : -

2.Number Tab-> Integer ->#.##0;(#.##0)

It's adding values to another expression.I need comma separated values.

Please any help can be appreciated.

Regards

Krishna

sushil353 — Tue, 30 Dec 2014 06:03:21 GMT

Hi,

Try :

Aggr(Concat(expression,','),dimension)

HTH

Sushil

krishna20 — Tue, 30 Dec 2014 06:23:20 GMT

Hi Sushil,

It's Not working for me.

Regards

Krishna

jagan — Tue, 30 Dec 2014 06:27:40 GMT

Hi,

Try this expression

=Concat(Aggr(DimensionName, DimensionName), ',', DimensionName)

Regards,

Jagan.

krishna20 — Tue, 30 Dec 2014 07:32:48 GMT

Hi ,

Thank you for your suggestions.

It's working by following this link. and small modification.#.##0;(#.##0). Here i replaced comma.#,##0;(#,##0)

Regards

Krishna