topic Re: Problem during import excel file in QlikView

Problem during import excel file

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

Hello Community

i have the following problem.

When i import the excel file to qlikview with the option "Embedded Labels", the content of some column change (screenshots). After the import i want to convert it into a crosstable so it is necessary that the content is the same.

What can i do to prevent this.

Thanks in advance

Carsten

Re: Problem during import excel file

lorenzoconforti — Mon, 12 Feb 2018 17:30:37 GMT

That's the actual value in the Excel file; if you open the xml file you will see what value is against that cell (see below). I don't think QV is changing anything, just displaying differently

Re: Problem during import excel file

lorenzoconforti — Mon, 12 Feb 2018 17:48:09 GMT

Please read here:

Numeric precision in Microsoft Excel - Wikipedia

I believe the impact of this is:

- when you open the file in Excel you cannot see there are missing decimals (as excel cannot display them); you can only see those values in the xml file

- when you open it with Qlikview, I guess if you are dealing with the data it will use the excel representation of that number (i.e. truncated); if you are defining the labels it will read the actual data (i.e. without truncation bypassing excel limit). I'm not 100% sure this is what happening but it looks likely to be the cause of your problem

Re: Problem during import excel file

ychaitanya — Mon, 12 Feb 2018 18:38:53 GMT

Change the Format of the Label in the Excel Sheet.

Right Click- > Format Cells -> Number

I have worked on the similar situation which has helped me before,

Thanks