Discussion Board for collaboration on QlikView Scripting.
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.
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.
All value contain - at right then try
if it contain +ve as well as -ve values then try
'-'&SubField(Data,'-',1) as ModData
Hope this helps,
=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