5 Replies Latest reply: May 31, 2012 9:28 AM by DK_ASN 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 ?