Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Developer's error

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

1 Solution

Accepted Solutions
Not applicable

Developer's error

left(Index(RATE,'.')-1)&mid(RATE,Index(RATE,'.'),3)

try to form this piece of code and got my problem solved

9 Replies

Re: Developer's error

Hi,

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.

Rgds

Anand

Not applicable

Developer's error

thnx but im loosing my data also there are not only this  value i have many value is 1289.34  1..and different more

Not applicable

Developer's error

all i want to remove i that 1 after that value...

Not applicable

Developer's error

Hi Praveen,

You can use subfield function to truncate unwatned number,

Eg : num(SubField('19300.020  1',' ',1),'##0.0##')

Good Luck

Developer's error

Hi,

Try to make whole column in num like

num( Rate , '#,##0.##', '.' , ',' )

Rgds

Anand

Developer's error

Hi,

Do you share any sample file for that.

Rgds

Anand

Not applicable

Developer's error

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

Not applicable

Developer's error

left(Index(RATE,'.')-1)&mid(RATE,Index(RATE,'.'),3)

try to form this piece of code and got my problem solved

Not applicable

Developer's error

first collected the '.' position by using Index() then found the 2 values after dot and append with the value beofre '.'

Community Browser