topic Re: Excel & CSV Amount problem loading in QlikView

Excel & CSV Amount problem loading

bsbernabe — Wed, 25 Nov 2020 16:16:04 GMT

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

80364.88

80364.875

Best Regards,

Bing

Re: Excel & CSV Amount problem loading

tamilarasu — Thu, 03 May 2018 02:57:44 GMT

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;

Front End:

Re: Excel & CSV Amount problem loading

bsbernabe — Thu, 03 May 2018 03:11:20 GMT

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

Re: Excel & CSV Amount problem loading

bsbernabe — Thu, 03 May 2018 03:15:26 GMT

Hi Tamil,

I already do that but still the same

Re: Excel & CSV Amount problem loading

tamilarasu — Thu, 03 May 2018 03:24:11 GMT

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.