10 Replies Latest reply: Oct 2, 2015 9:19 AM by Joanna Seldon RSS

    group by date SQL Qlik Sense

    Joanna Seldon

      Hiya

       

      I have a table loaded in via a SQL server,

       

      however, the filter pain for Order_Date

       

      is showing multiple order date instances

       

      e.g

       

      04/04/2015

      04/04/2015

      04/04/2015

      04/04/2015

      06/04/2015

      06/04/2015

      06/04/2015

      07/04/2015

       

      I wish it to show

       

      04/04/2015

      06/04/2015

      07/04/2015

       

      is there a way of grouping by the date??

       

      I have a calendar, and the based on the order date

       

      I have tried

       

      day(Order Date) in expression

       

      and the same happens

       

      please help