2 Replies Latest reply: Jun 4, 2016 1:22 AM by Shamit Shah RSS

    Date expression

    Shamit Shah

      Hi,

       

      I have the following expression in QlikView ,

       

      =num(Count (DISTINCT if(OrderDate>=('01/07/2015'),InvoiceNumber)),'#,##0','.',',')

       

      which I want to apply in Qlik Sense.

       

      I tried the following, but not getting any result

      Count(Distinct {<OrderDate = { "<$(=>01/07/2015)" }>}InvoiceNumber)

       

      Any idea on what the correct expression should be?

       

      Thanks

      Shamit