How to shift minus sign from right side to left side

[nehasaxena]

Hello,

There are minus signs are on right side in the excel file that I am receiving from database team.

For example - 1.333-

Please help me to fix this in Qlikview.

Thanks.

Neha

[Anonymous]

Does every field value are like this?

Could you share a sample?

[Anonymous]

Try sth like this at script?

=SubField('1.333-','-',1)*-1

or

=SubField('YourField','-',1)*-1

[tamilarasu]

Try something like below,

Load

If(Right(A,1)='-',Right(A,1)&Left(A,Len(A)-1),A) as FieldName

From

File;

Replace A with your required field name.

[marcus_sommer]

You could use num#() - see: Reading SAP data that is positive and negative

- Marcus

[PrashantSangle]

Hi,

All value contain - at right then try

purgechar(FieldName,'-')*-1

if it contain +ve as well as -ve values then try

if(wildmatch(FieldNAme,'*-*'),purgeChar(FieldName,'-')*-1,FieldNAme)

Regards

[Anonymous]

Marcus,

I tried like this but no change

=Num#('1.333-')  ///returning 1.333- only

[tresesco]

Num(Num#('1.333-'))  -> Returns :   -1.333

[HirisH_V7]

Hi,

Check this,

Data:
LOAD *,
'-'&SubField(Data,'-',1)  as ModData


INLINE [
Data
1.333-
];

Front end:

PFA,

Hope this helps,

Hirish

[tresesco]

=Num#('1.333-')  returns 1.333- which is actually dual number (it is internally -1.333). If you try applying any mathematical operation on it, you would see that. I.e

Num#('1.333-')*10  returns -13.33   correctly.

So solution (to see the number correctly), try:

Num(Num#('1.333-')) returns  -1.333