topic Re: Problem with dates in selections for script in QlikView

Problem with dates in selections for script

Thu, 16 Jun 2016 12:42:35 GMT

Good afternoon,

any suggestions why below scripts fails with message "Garbage after statement"?

Thanks!

SET ThousandSep='.';
SET DecimalSep=',';
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='#.##0,00 €;-#.##0,00 €';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD.MM.YYYY';
SET TimestampFormat='DD.MM.YYYY hh:mm:ss[.fff]';
SET MonthNames='Jan;Feb;Mrz;Apr;Mai;Jun;Jul;Aug;Sep;Okt;Nov;Dez';
SET DayNames='Mo;Di;Mi;Do;Fr;Sa;So';

set DayForSelection = 23.05.2016;

Directory;
LOAD
Personalnr as Personalnummer,
// [Gültig bis],
// [Gültig ab],
[ID/Nummer] as UserID
FROM
PA0105.xls
(txt, unicode, embedded labels, delimiter is '\t', msq, header is 3 lines, no eof) where [Gültig ab] < $(DayForSelection) and $(DayForSelection) <= [Gültig bis];

Re: Problem with dates in selections for script

sunny_talwar — Thu, 16 Jun 2016 12:43:23 GMT

Can you try this:

SET ThousandSep='.';
SET DecimalSep=',';
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='#.##0,00 €;-#.##0,00 €';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD.MM.YYYY';
SET TimestampFormat='DD.MM.YYYY hh:mm:ss[.fff]';
SET MonthNames='Jan;Feb;Mrz;Apr;Mai;Jun;Jul;Aug;Sep;Okt;Nov;Dez';
SET DayNames='Mo;Di;Mi;Do;Fr;Sa;So';

SET DayForSelection = 23.05.2016;

Directory;
LOAD
Personalnr as Personalnummer,
// [Gültig bis],
// [Gültig ab],
[ID/Nummer] as UserID
FROM
PA0105.xls
(txt, unicode, embedded labels, delimiter is '\t', msq, header is 3 lines, no eof) where [Gültig ab] < '$(DayForSelection)' and '$(DayForSelection)' <= [Gültig bis];

Re: Problem with dates in selections for script

sunny_talwar — Thu, 16 Jun 2016 12:43:56 GMT

Or may be this:

SET DayForSelection = Num(MakeDate(2016, 5, 23));

Directory;
LOAD
Personalnr as Personalnummer,
// [Gültig bis],
// [Gültig ab],
[ID/Nummer] as UserID
FROM
PA0105.xls
(txt, unicode, embedded labels, delimiter is '\t', msq, header is 3 lines, no eof) where [Gültig ab] < $(DayForSelection) and $(DayForSelection) <= [Gültig bis];

Re: Problem with dates in selections for script

Thu, 16 Jun 2016 12:47:20 GMT

That works, thanks!