Importing Excel Values to Qlikview

[#1]

Hi,

I am facing a problem which seems to have an easy solution. But unfortunately I am not able to work out. I have attached the excel file and qlikview application. I want to get the data as it is in the Excel sheet in the Qlikview application(Straight table)[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/6646.test1.xlsx:550:0].

Regards,

Mandar

[#2]

Hi,

You mean to say that you don't want % symbol in the value column for D and E row?

[#3]

Hi,

Yes. I dont want the '%' symbol - provided the numerical values appears exactly the same as they are in the excel sheet in the Qlikview Application(Without making any changes in the database). Thanks for your interest.

[prieper]

What is wrong with a script like

LOAD
 Product,
 Value
FROM
 [.\6646.test1.xlsx]
 (ooxml, embedded labels, table is Sheet1);

Think that all figures are loaded either as 1 or 0.95 or 85.26. If the latter is supposed to be a percentage than you may include a formula like

LOAD
 Product,
 IF(Value > 1, Value/100, Value) AS Value
FROM
 [.\6646.test1.xlsx]
 (ooxml, embedded labels, table is Sheet1);

HTH
Peter