5 Replies Latest reply: May 31, 2012 9:28 AM by Annette Søgaard RSS

    count distinct with a condition

      i'm new to qlikview
      i want to make an expression in Qlikview which will count number of late order

      in SQL it will be like this
      SELECT [OrderID] FROM [table] where ShippedDate>RequiredDate


      i try this expression

      Count(DISTINCT if (ShippedDate>RequiredDate,OrderID)
      but it give me wrong result


      can anyone help me ?