topic Re: Problems load data from excel in QlikView

Problems load data from excel

Mon, 27 Aug 2012 13:47:24 GMT

Hi All

I have a problem loading some data from excel. I try to load these data.

Distribution Cost		Month Actual	Month Budget	Month l/y	Index Budget	Index l/y
Denmark	kDKK	1.289	1.745	1.507	74	86
Denmark	% Act	2,35%	2,99%	2,66%
Denmark	% T/O	1,00%	1,30%	1,20%
Denmark	Cost/m3	72	90	79	80	90
Denmark	Cost/m3 C.	71	88	79	81	89
Denmark	Km	159	155	158	103	101

But when I load the data I can not see the %-figures, but I ca find the text called % Act. Can somebody tell me why and what to do for solve it? (see report output in file)

Best regards

Bjarne

Re: Problems load data from excel

whiteline — Tue, 28 Aug 2012 10:23:34 GMT

Its hard to help without looking to your script

Re: Problems load data from excel

Tue, 28 Aug 2012 10:27:52 GMT

The script look like this

C190_Distribution_Cost:

LOAD
      1 as Month,
      'C190' as Site,
      [Distribution Cost],
     F3 as Key,
     [Month Actual],
     [Month Budget],
     [Month l/y],
     [Index Budget],
     [Index l/y],
     [Ytd Actual],
     [Ytd Budget],
     [Ytd l/y],
     [Index Budget1],
     [Index l/y1]

FROM

(biff, embedded labels, header is 41 lines, table is C190$)

WHERE RecNo() > 0 AND RecNo() < 25;

Re: Problems load data from excel

subin6600 — Tue, 28 Aug 2012 10:31:55 GMT

Hi Bjarne,

I tried to take samble data with % as well.. If you need % as it is here are the settings.

Please check the screenshot attached.

Regards,
Subin Thomas

Re: Problems load data from excel

Tue, 28 Aug 2012 10:37:18 GMT

I tried that also. But have mixed data. So some figures sould be shown in % and other as number. So this is not the solution 😞

Re: Problems load data from excel

subin6600 — Tue, 28 Aug 2012 10:45:56 GMT

The best solution is then if you Excel is not dynamic you could probably change the whole column which has mixed values to be in text format.

This would make qlikview also to read in the same way use text(<column name>) as <column name>

Re: Problems load data from excel

jagannalla — Tue, 28 Aug 2012 10:56:18 GMT

Please provide sample data. B'coz i can able to see the % symbol if i load the data through the excel. Please c this image.

Re: Problems load data from excel

Tue, 28 Aug 2012 11:01:27 GMT

Hi Jagan

How did you do that? Do you need more data? What are your settings?

Best regards

Bjarne

Re: Problems load data from excel

jagannalla — Tue, 28 Aug 2012 11:07:19 GMT

I just taken the data in excel which you provided in first post. Please check this excel.

Re: Problems load data from excel

subin6600 — Tue, 28 Aug 2012 11:10:23 GMT

Jagans Excel all the cell properties are in default General category. And so the data is read in the same way.

Regards,
Subin

Re: Problems load data from excel

jagannalla — Tue, 28 Aug 2012 11:15:27 GMT

That's y i asked you to provide sample data wt you have now. B'coz if i take the data in inline i can also see the result.

Re: Problems load data from excel

kji — Tue, 28 Aug 2012 11:43:14 GMT

Looking at your table it looks like the numbers with the % is imported as text (they are left adjusted in the column), maybe the original poster was using a numeric expression on the field.

Re: Problems load data from excel

whiteline — Tue, 28 Aug 2012 15:14:18 GMT

maybe the original poster was using a numeric expression on the field

Exactly.

Its hard to help without looking to your script