Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have to get the data from my table using start and stop date using in our table and i have written a code but it is not working giving error that field not found.
please correct the code if you find any error.
MinMaxDates:
LOAD Floor(Min(TimeStamp#(START_DATE, 'DD.MM.YYYY hh:mm'))) AS MinDate,
Floor(Max(TimeStamp#(END_DATE, 'DD.MM.YYYY hh:mm'))) AS MaxDate
RESIDENT R_DELAY;
LET vMinDate = FieldValue('MinDate', 1);
LET vMaxDate = FieldValue('MaxDate', 1);
CalendarTemp:
LOAD DayStart(TimeStamp($(vMinDate) + (RecNo()/60/24) + (IterNo() -1))) AS AddedDate, // Use this one as date
TimeStamp($(vMinDate) + (RecNo()/60/24) + (IterNo() -1)) AS AddedTimeStamp
AUTOGENERATE 86399 WHILE $(vMinDate) + IterNo() -1 <= $(vMaxDate);
DROP TABLE MinMaxDates;
Make sure R_DELAY contains the fields START_DATE and END_DATE. Qlikview is case sensitive with regards to field names so START_DATE, Start_Date and start_date are all different fields to Qlikview.
I do this by:
Dear Gysbert,
thanks for the reply. I have the same field name in correct case. But still I m getting the error.