Discussion Board for collaboration on QlikView Scripting.
I am new with the QV and working on the training.
I can't load the resident table I create, here is the script
$(VARMINDATE)+ROWNO()-1 AS DATENUMBER,
DATE ($(VARMINDATE)+ROWNO()-1) AS TEMPDATE,
no error message pops up,
The debugger shows,
Is there something wrong with the autogenerate?
You have a syntax error due to the comma before AutoGenerate. But I think your problem should be in the variable assignments. If you try the following script, it will work:
SET VARMINDATE = MakeDate(2012, 1, 1);
SET VARMAXDATE = MakeDate(2012, 12, 31);
DATE ($(VARMINDATE)+ROWNO()-1) AS TEMPDATE
I've tried to remove the comma, but I get an "ERROR IN EXPRESSION" message in the debugger.
regarding the SET function, I cannot put specific dates I must use the min and the max dates of the ORDERDATE field of the ORDERS table.
OK, then take a look at this one:
LOAD A AS LoadedDates
(ooxml, no labels, table is Dates);
Max(LoadedDates) AS MaxDate,
Min(LoadedDates) AS MinDate
VARMINDATE = Peek('MinDate');
VARMAXDATE = Peek('MaxDate');
it works this way,
I commented out the initial script and created the Dates file.
However, what happens with the script from training?