Discussion Board for collaboration related to Creating Analytics for QlikView.
I would like to reload data only for the last day of each month (end of month information).
I would like my data to only read
thank you in advance.
May be this
Where Date = Floor(MonthEnd(Date));
would this be correct? it won't load the data.
Date (date(date#(DATE, 'YYYYMMDD'),'YYYY/MM/DD')) as EOM
WHERE EOM = Floor(MonthEnd(EOM));
This because EOM is not a field in this load... it will be a field after this load
Date(Date#(DATE, 'YYYYMMDD'),'YYYY/MM/DD') as EOM
WHERE EOM = Floor(MonthEnd(Date#(DATE, 'YYYYMMDD')));
what is the definition of "Floor"? i'm trying it like this also and it wont load data.
WHERE XDATE = Floor(MonthEnd(Date#(XDATE, 'YYYYMMDD')));
would be fine
MonthEnd gives a time stamp to the last second of the day....this isn't comparable to a month end date... so in order to make them equal... we need to use Floor (Floor essentially truncates the time portion from the timestamp)
thank you both for all the great information. !!!