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