topic Exclude Value after Decimal while loading in QlikView

Exclude Value after Decimal while loading

Tue, 26 Apr 2011 13:16:03 GMT

Dear All,

I have some data in Excel Sheet,where in a Field i some data with decimal values i want to exclude the decimal value while loading.

Ex : field name as Transactional_Amount : data are there like 125.25,1000.65,258.003.........

I want to exclude decimal values while loading data in QV application so, that when in application i check field Transactional Amount it should show data like : 125,1000,258

Please help its Urgent.

Kind Regards,

Pranav

Exclude Value after Decimal while loading

disqr_rm — Tue, 26 Apr 2011 13:22:25 GMT

You may use FLOOR() function, like:

LOAD floor(125.25) as f AutoGenerate 1;

Exclude Value after Decimal while loading

Tue, 26 Apr 2011 13:29:43 GMT

Or you can use subfield()

subfield(Transactional_Amount, '.', 1) as Transactional_Amount

but it's better to use floor() as Rakesh suggest

Exclude Value after Decimal while loading

Sat, 30 Apr 2011 07:17:13 GMT

Thanks Rakesh and Muncho it Works through Floor()

Regards,

Pranav