topic Importing Excel Values to Qlikview in QlikView

Importing Excel Values to Qlikview

Fri, 11 Dec 2009 12:20:32 GMT

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

Importing Excel Values to Qlikview

Fri, 11 Dec 2009 12:56:36 GMT

Hi,

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

Importing Excel Values to Qlikview

Fri, 11 Dec 2009 13:07:52 GMT

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.

Importing Excel Values to Qlikview

prieper — Sat, 12 Dec 2009 04:52:05 GMT

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