5 Replies Latest reply: May 31, 2012 9:28 AM by IntrumASN RSS

    count distinct with a condition

    freaksmj

      hi
      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 ?