Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

qvraj123
Contributor II

Impact of Floor() when reading date fields from QVD...please advise

Hi All,

Thanks for your time - I have an app where we read the data from QVD and there are many date fields which are in MM/DD/YYYY format in the QVD but for some reason they have used date(floor(field),'MM/DD/YYYY') again the QVW file where the read from QVD happens - does this impact as we have 3.5M records reading from QVD

should I take off the floor() - when I pull the date field into list box from the QVD they are showing up on the right hand side of the list box - thanks again for your time

5 Replies
MVP & Luminary
MVP & Luminary

Re: Impact of Floor() when reading date fields from QVD...please advise

floor() is used on dates to remove any time value (which is a fraction) from the field.  If your dates are already whole numbers, floor() is unnecessary and will slow down your reload.   You can confirm if they are already whole numbers by loading the field, put in a listbox and change the number format to timestamp.  If they all show 12:00 AM they are good as is.

-Rob

trdandamudi
Honored Contributor

Re: Impact of Floor() when reading date fields from QVD...please advise

If it is already in 'MM/DD/YYYY' then you do not need the floor function.

 

Highlighted
qvraj123
Contributor II

Re: Impact of Floor() when reading date fields from QVD...please advise

 

 

Thank you Rob, when I go to listbox and click on ve

Capture.PNG

qvraj123
Contributor II

Re: Impact of Floor() when reading date fields from QVD...please advise

Hi, Thanks for your time,

Like Rob mentioned I take the date field as is from the QVD and put into the list box it is showing as

>list box > Number > override > timestamp - if click on timestamp it is showing as below

8/31/2018  12:00:00 AM  - so I think I should keep the floor as is - right?

Thanks again

trdandamudi
Honored Contributor

Re: Impact of Floor() when reading date fields from QVD...please advise

Yes, you are good to go....