18 Replies Latest reply: Mar 24, 2018 4:12 AM by Manish Kachhia RSS

    Count of Min(Date) in line graph is not working in Qliksense

    Supriya R

      Hi,

       

      i have table with below fields,

       

      LOAD `invitation_id`,

          `client_id`,

          `batch_meta_data_id`,

          first_email_send_date, // timestamp

          date(floor(first_email_send_date),'MM-DD-YYYY') as formatted_send_date,

         opened ;

      from INVITATION table;

       

      so to get counts of opens for particular batch_meta_data_id for min(first_email_send_date). i am using like below

      tried these expressions:

      count({$<batch_meta_data_id={'96'}, formatted_send_date= {"=$(=Min(formatted_send_date))"},opened = {'1'}>}distinct invitation_id)

      count({$<batch_meta_data_id={'96'}, formatted_send_date= {"=$(=Date(Min(formatted_send_date),'MM-DD-YYYY'))"},opened = {'1'}>}distinct invitation_id)


      Dimension: Hour(first_opened_date)


      But i am getting Zero.

      What am i doing wrong. Please help me.