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';


      LOAD sold_date as "parts_sold_date",

        Year(sold_date) as "parts_sold_year",

          Month(sold_date) as "parts_sold_month",






      SELECT "sold_date",





      FROM "database"."oldparts";


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