Discussion Board for collaboration on QlikView Layout & Visualizations.
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!
Num#(CostDailyDeltaUSD,'#,##',',','.') as ExtendedCostUSDADJ,
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
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 MoneyFormat='€ #.##0,00;-€ #.##0,00';
SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';
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,