Problems load data from excel

[#1]

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

[whiteline]

Its hard to help without looking to your script

[#3]

Hi

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;

[subin6600]

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

[#5]

Hi

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 😞

[subin6600 · Accepted solution]

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>

[jagannalla]

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.

[#8]

Hi Jagan

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

Best regards

Bjarne

[jagannalla]

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

[subin6600]

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

Regards,
Subin