topic Developer's error in QlikView

Developer's error

Tue, 01 Nov 2011 07:58:41 GMT

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

Re: Developer's error

its_anandrjs — Tue, 01 Nov 2011 08:08:57 GMT

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

Developer's error

Tue, 01 Nov 2011 08:17:51 GMT

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

Developer's error

Tue, 01 Nov 2011 08:20:43 GMT

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

Developer's error

Tue, 01 Nov 2011 08:24:24 GMT

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

its_anandrjs — Tue, 01 Nov 2011 08:29:21 GMT

Hi,

Try to make whole column in num like

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

Rgds

Anand

Developer's error

its_anandrjs — Tue, 01 Nov 2011 11:03:27 GMT

Hi,

Do you share any sample file for that.

Rgds

Anand

Developer's error

Tue, 01 Nov 2011 11:39:26 GMT

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

Developer's error

Tue, 01 Nov 2011 14:11:51 GMT

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

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

Developer's error

Tue, 01 Nov 2011 14:31:10 GMT

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