Issue in loading the data from excel to Qlikview

[#1]

Hi,

I see that the data when imported from excel to qlikview is not of the same data type.In my sample application i have four Metric Values wherein the first three are % values and the fourth metric value represents the number of hours but when I load the excel to qlikview i see that the chart is representing the % values as decimals like 99.99% is shown as 0.99.So can anyone please help me know how I could maintain the original data type present in the excel to be as is in qlikview also.I have attached the sample application and the excel file for reference.

Regards,

Smitha

[jagan]

Hi,

Qlikview reads the numbers from excel in actual format without the % symbol, to display those numbers in % try like below

Properties -> Number tab -> Select Integer/Fixed to/Number and select Show In Percentage option.

Hope this helps you.

Regards,

Jagan.

[jonathandienst]

Or you can explicitly set the data type during load, like this

LOAD

     Num(field1, '0.0%') As field1,

     Num(field2, '0.0%') As field2,

     Num(field3, '0.0%') As field3,

     field4,

     ...

[deepakqlikview_123]

Hi,

go in number formt  of excel sheet  and do proper formatting for that column.

otherwise in qlikview chart properties check option show data in percentage.

Thanks,

Deepak