Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problems load data from excel

Hi All

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

Distribution CostMonth ActualMonth BudgetMonth l/yIndex BudgetIndex l/y
DenmarkkDKK1.2891.7451.5077486
Denmark% Act2,35%2,99%2,66%
Denmark% T/O1,00%1,30%1,20%
DenmarkCost/m37290798090
DenmarkCost/m3 C.7188798189
DenmarkKm159155158103101

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

1 Solution

Accepted Solutions
subin6600
Creator III
Creator III

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>explanation.JPG

View solution in original post

12 Replies
whiteline
Master II
Master II

Its hard to help without looking to your script

Not applicable
Author

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
Creator III
Creator III

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.

explanation.JPG

Regards,
Subin Thomas

Not applicable
Author

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
Creator III
Creator III

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>explanation.JPG

jagannalla
Partner - Specialist III
Partner - Specialist III

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.

1.png

Not applicable
Author

Hi Jagan

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

Best regards

Bjarne

jagannalla
Partner - Specialist III
Partner - Specialist III

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

subin6600
Creator III
Creator III

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

Regards,
Subin