Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Ignore time formatting when loading file

Hi!

I'm trying to load an excel file that has a column of rows that is wrongly formatted as hh:mm:ss but the actual format should be mm:ss.

So, for example i have a field that shows 07:22:00 but it should be 00:07:22.

When I try to load this file into QlikView I can't make it ignore this format.

If you open the csv-file in excel it will at first glance look like its correctly formatted but when you look in the expression field you will see the problem.

This is in reality a very large file that will be loaded daily so I really can't chenge anything in the csv-file, it has to be done in QV.

Will really appreciate any help with this.

Tags (1)
1 Solution

Accepted Solutions
fdelacal
Valued Contributor

Re: Ignore time formatting when loading file

change in your script.

time(time#(Servicing,'mm:ss'),'hh:mm:ss') as Servicing

Hope that helps you.

2 Replies
fdelacal
Valued Contributor

Re: Ignore time formatting when loading file

change in your script.

time(time#(Servicing,'mm:ss'),'hh:mm:ss') as Servicing

Hope that helps you.

Not applicable

Re: Ignore time formatting when loading file

Thank you so much for your help, it works great!!!

Community Browser