Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
marius_larsen
Creator II
Creator II

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
Creator III
Creator III

Hi there,

It's very possible that when you are pulling the data from web page it stores is as time stamp (format HH:MM:SS) 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
Creator II
Creator II
Author

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
Creator III
Creator III

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
Creator II
Creator II
Author

i think it comes as text, yes.