topic Re: How to shift minus sign from right side to left side in QlikView

How to shift minus sign from right side to left side

nehasaxena — Wed, 13 Jan 2016 06:22:14 GMT

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

Re: How to shift minus sign from right side to left side

Anonymous — Wed, 13 Jan 2016 06:28:24 GMT

Does every field value are like this?

Could you share a sample?

Re: How to shift minus sign from right side to left side

Anonymous — Wed, 13 Jan 2016 06:31:21 GMT

Try sth like this at script?

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

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

Re: How to shift minus sign from right side to left side

tamilarasu — Wed, 13 Jan 2016 06:37:36 GMT

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.

Re: How to shift minus sign from right side to left side

marcus_sommer — Wed, 13 Jan 2016 06:38:39 GMT

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

- Marcus

Re: How to shift minus sign from right side to left side

PrashantSangle — Wed, 13 Jan 2016 06:40:03 GMT

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

Re: How to shift minus sign from right side to left side

Anonymous — Wed, 13 Jan 2016 06:50:49 GMT

Marcus,

I tried like this but no change

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

Re: How to shift minus sign from right side to left side

tresB — Wed, 13 Jan 2016 06:51:17 GMT

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

Re: How to shift minus sign from right side to left side

HirisH_V7 — Wed, 13 Jan 2016 06:54:30 GMT

Hi,

Check this,

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


INLINE [
Data
1.333-
];

Front end:

PFA,

Hope this helps,

Hirish

Re: How to shift minus sign from right side to left side

tresB — Wed, 13 Jan 2016 06:55:04 GMT

=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

Re: How to shift minus sign from right side to left side

Anonymous — Wed, 13 Jan 2016 06:55:37 GMT

How it is interpreting '-' and '+' only ?

Why not others?

Re: How to shift minus sign from right side to left side

A7R3 — Thu, 11 Aug 2022 04:06:39 GMT

I found out that this works.

=NUM#(Qty, '# ; #-') * 1