Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
You mean to say that you don't want % symbol in the value column for D and E row?
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.
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