Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Importing Excel Values to Qlikview

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

3 Replies
Not applicable
Author

Hi,

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

Not applicable
Author

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
Master II
Master II

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