Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Loading from excel, formatting is lost

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:

        

Hours as displayed in excelData (values) read by Qlikview
281.166667
180.75
251.041667
251.041667
261.083333
241
230.958333
180.75
60.25
60.25
70.291667
50.208333

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

3 Replies
Highlighted
Employee
Employee

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

Regards,
Mike Tarallo
Qlik
Highlighted
Not applicable

I am using Qlikview, apologize for mixup.

Highlighted
Not applicable

Actually, I was able to figure it out.

I multiplied the LOAD by 24.

Thank you. please remove/delete if necessary