5 Replies Latest reply: Feb 26, 2017 4:49 AM by clark meyers RSS

    limit rows from sql

    clark meyers

      hello,

       

      i want to limit the data load from a odbc-datasource.

       

      select * from my_database where my_type = 42.

      my_type is of data type integer.

       

      Unfortunately qlik does not take this condition and loads everything.

       

      what is the right syntax for qlik-sense ?

      is there a cast or something necessary ?

       

      thx for your hints!