Discussion Board for collaboration on QlikView Scripting.
hi i have a field in table called Rate and its value are in decimal eg 19300.00 1 here i have a problem i have to do data massaging to remove the unwanted 1 which is present kindly help guys
Go to Solution.
try to form this piece of code and got my problem solved
Use Round( ) function
Like Round( YourColumn, 0.1 )
or you can also set the decimal place in the chart properties in the number tab select Expression -> Fixed to -> 2 Dicimal place.
thnx but im loosing my data also there are not only this value i have many value is 1289.34 1..and different more
all i want to remove i that 1 after that value...
You can use subfield function to truncate unwatned number,
Eg : num(SubField('19300.020 1',' ',1),'##0.0##')
Try to make whole column in num like
num( Rate , '#,##0.##', '.' , ',' )
Do you share any sample file for that.
i have used LEFT(RATE,8) and since i have gone through all the data and it contains all till 8 feilds only i have got what i want thnx guys this R&D would not have been possible without your help
first collected the '.' position by using Index() then found the 2 values after dot and append with the value beofre '.'