topic Re: Issue in loading the data from excel to Qlikview in QlikView

Issue in loading the data from excel to Qlikview

Tue, 19 Jan 2016 06:37:18 GMT

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

Re: Issue in loading the data from excel to Qlikview

jagan — Tue, 19 Jan 2016 06:52:01 GMT

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.

Re: Issue in loading the data from excel to Qlikview

jonathandienst — Tue, 19 Jan 2016 07:02:10 GMT

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,

...

Re: Issue in loading the data from excel to Qlikview

deepakqlikview_123 — Tue, 19 Jan 2016 07:22:09 GMT

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