topic Re: Loading from excel, formatting is lost in QlikView

Loading from excel, formatting is lost

Tue, 05 Aug 2014 19:14:21 GMT

I am trying to load a column that has a format - (Hour format)

Excel displays it as normal integers,

1 to 500 hours

However, Qlikview reads it as the "value" format (back end format prior to the hour conversion)

For example:

Is there anyway I can load what is being displayed?

I know this might be unclear, please paste the right column into excel and format cells as custom. Type .

Thanks in advance

Michael_Tarallo — Tue, 05 Aug 2014 19:31:44 GMT

Hi Cedric - just making sure - are you using QlikView and not Qlik Sense? If so I will move this over to the appropriate forum.

Mike

Tue, 05 Aug 2014 19:33:29 GMT

I am using Qlikview, apologize for mixup.

Tue, 05 Aug 2014 19:48:56 GMT

Actually, I was able to figure it out.

I multiplied the LOAD by 24.

Thank you. please remove/delete if necessary