topic Import csv into qlikview in QlikView

Import csv into qlikview

qlikviewaf — Thu, 06 Sep 2018 13:57:37 GMT

Guys,

i'm trying to import in qlik the excel file attached with the qvw file attached as well.

the issue is that numbers on the CSV file are with " " quote, and qlikview sometimes is not able to get the amount, i dont know why.

For exmaple the sum of ExtendedCostUSDADJ for 06/09/2018 field have to be 6451,224 but i got only 2586,44 since one line is ignored and read as text

Can anyone please help?
Thanks!

stigchel — Thu, 06 Sep 2018 14:15:36 GMT

Try with

Num#(CostDailyDeltaUSD,'#,##',',','.') as ExtendedCostUSDADJ,

tulabandula — Thu, 06 Sep 2018 14:24:10 GMT

Try below

Your numbers or dates are coming into Excel formatted as Text.

To convert in Excel, click column A and change the format to Short Date/Number.

Then select Data|Text to columns and click Finish

Instead of using Send to Excel:

If you are using the IE PlugIn, you can right-click and choose Copy to Clipboard|Full Table. Then paste into Excel

Right-Click and Export to csv. Then open in Excel

qlikviewaf — Thu, 06 Sep 2018 16:28:41 GMT

it works - but which formula i have to use if i use this setup (which is the one i have to use): ?

if i set the app with the following is not working anymore - can you please help? THanks!!

SET ThousandSep='.';

SET DecimalSep=',';

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

SET MoneyFormat='€ #.##0,00;-€ #.##0,00';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

SET FirstWeekDay=0;

SET BrokenWeeks=0;

SET ReferenceDay=4;

stigchel — Thu, 06 Sep 2018 17:19:11 GMT

It worked but you had different settings then?? I'm away from qv install right now, so unable to check. Could you try with

Num(Num#(CostDailyDeltaUSD,'#,##',',','.')) as ExtendedCostUSDADJ,