Discussion Board for collaboration on QlikView Scripting.
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.
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.
It's very possible that when you are pulling the data from web page it stores is as time stamp (format HH:MMS) 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.
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
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.
i think it comes as text, yes.