3 Replies Latest reply: Aug 3, 2016 6:12 AM by Sunny Talwar RSS

    error in expression in qliksense

    Supriya R

      Hi,

       

      I am getting count of datecreated, where my sql query will be

       

      select count(*) from Datatable where  date_created > '2016-06-17 20:00:00'  and date_created < '2016-06-22 00:00:01';

       

      In my qliksense, i have

       

      Count({$<datecreated > {'2016-06-17 20:00:00'},datecreated < {'2016-06-22 00:00:01'}>}datecreated)

       

      but its giving me expression error.

       

      what i am missing here,Please help me on this.

       

       

      Regards,

      Supriya