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.
Does every field value are like this?
Could you share a sample?
Try sth like this at script?
Try something like below,
If(Right(A,1)='-',Right(A,1)&Left(A,Len(A)-1),A) as FieldName
Replace A with your required field name.
You could use num#() - see: Reading SAP data that is positive and negative
I tried like this but no change
=Num#('1.333-') ///returning 1.333- only
=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
All value contain - at right then try
if it contain +ve as well as -ve values then try
Num(Num#('1.333-')) -> Returns : -1.333
How it is interpreting '-' and '+' only ?
Why not others?
'-'&SubField(Data,'-',1) as ModData
Hope this helps,
Retrieving data ...