8 Replies Latest reply: Apr 8, 2015 4:58 AM by Rod Jager RSS

    Load dates greater than 27-12-2014 in the script editor

    Dennis Bos

      I tried various ways to filter the dates greater than 27-12-2014 in de Script Editor of Qlikview.

      I don't know where and if I use HEAVING or WHERE. Or maybe it can be done white another statement.

       

      These are the setting:

       

       

      SET ThousandSep='.';
      SET DecimalSep=',';
      SET MoneyThousandSep='.';
      SET MoneyDecimalSep=',';
      SET MoneyFormat='€ #.##0,00;€ -#.##0,00';
      SET TimeFormat='h:mm:ss';
      SET DateFormat='DD-MM-YYYY';
      SET TimestampFormat='DD-MM-YYYY h:mm:ss[.fff]';
      SET MonthNames='jan;feb;mrt;apr;mei;jun;jul;aug;sep;okt;nov;dec';
      SET DayNames='ma;di;wo;do;vr;za;zo';

       

      The table is loaded like below.

      The StartDate column had a notation like: 2014-12-27 07:23:00,000

      The  Year, Month, Week and Days are correct.

       

       

      LOAD Name,
      StartDate,
      Year(StartDate),
      Month(StartDate),
      Week(StartDate),
      Day(StartDate),
      SQL SELECT Name,
      StartDate,
      FROM "Database".dbo.StartDates;

       

      How do I load only the dates greater then 27-12-2014?