Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

marius_larsen
Not applicable

Time format excel from web.

Hi,

i have 2 excelfiles with values for 2014 and 2015.

Am trying to load the values for 2016 YTD from a web page so it will update automaticaly every day.

One problem;

Hours from excel file is the same as the one from the web page, but when i load it in my QV modell it says its different and duplicates.

4 Replies
kuczynska
Not applicable

Re: Time format excel from web.

Hi there,

It's very possible that when you are pulling the data from web page it stores is as time stamp (format HH:MMSmiley FrustratedS) rather than HH:MM, which would explain why you're getting multiple results.

You should try to use FLOOR() function in load script.

Hope this helps.

marius_larsen
Not applicable

Re: Time format excel from web.

Hi,

hmm. just a floor function wouldnt solve it..

here is a screen show from the excelfile:

Hours is 'hh-hh'

it is from hour 00 to hour 01

from 01 to 02

from 02 to 03

any suggestions?

kuczynska
Not applicable

Re: Time format excel from web.

So - 'Hours' comes as text from what I understand, yes? There must be a difference between the values excel. Is the len() of each entry the same then?

Let's not forget that if 'Date' comes as a timestamp from the web page it could add some extra granularity to extracted data. Check num(Date) too just to make sure this field doesn't require a trim.

Maybe just upload a sample qvw with few rows of data.

marius_larsen
Not applicable

Re: Time format excel from web.

i think it comes as text, yes.