Excel & CSV Amount problem loading

[bsbernabe]

Hello There,

I have concern regarding loading data, the data source was .csv my concern once i run this at Qlikview the amount was change like bellow, kindly see the attached file sample data.

Product	Amount	Qlikview
D	80364.88	80364.875

Best Regards,

Bing

[tamilarasu]

Hi Bing,

Actually, the original value in excel is "80364.875".

If you want to format it like excel then we need to use Num function. You can do this in back end or front end.

Back End:

Data:

LOAD Product,

     Num(Amount,'###0.00') as Amount

FROM

Excel;

OR

Front End:

[bsbernabe]

Hi Tamil,

Thank you for quick respond, Yes but that's the original in excel when you run to Qlikview is something like this 80364.88,

what i want is to get like what in excel. is it possible?

See sample:

Product	Amount	Qlikview
A	80364.875	80,364.88
B	57444.6	57,444.59
C	41936.804	41,936.96
D	41943.9	41,944.07

[bsbernabe]

Hi Tamil,

I already do that but still the same

[tamilarasu · Accepted solution]

Hi Bing,

I am not sure how did you try this. Have a look at the attached file. It is working fine. If you still have any issues, please attach a sample file that shows your problem.