6 Replies Latest reply: Aug 16, 2016 3:04 PM by Casey Johnson RSS

    Filtering load data by date in Qlik Sense

    Casey Johnson

      New to Qlik Sense and can't seem to find a solution for this. I want to filter (limit) the data (from an individual table/source) being loaded by a field's date (ex"sold_date"). One thing to note is the field name was modified in the load statement ... not sure how that effects the solution/syntax. The date format for that field is "YYYY-MM-DD".

       

      LIB CONNECT TO 'PostgreSQL_database';

      [oldparts]:

      LOAD sold_date as "parts_sold_date",

        Year(sold_date) as "parts_sold_year",

          Month(sold_date) as "parts_sold_month",

        price_sold,

        who_sold,

        how_sold;

       

      [oldparts]:

      SELECT "sold_date",

        "price_sold",

        "who_sold",

        "how_sold",

       

      FROM "database"."oldparts";

       

      Where Date(sold_date) >= '2016-01-01';