topic Count Column inside QlikView in QlikView

Count Column inside QlikView

pgalvezt — Fri, 17 Feb 2012 14:36:07 GMT

Hello! I have created an expression =IF(FechaDoc - FechaPO < 0,'No Compliance','Compliance'). And I need to count the Compliance and No Compliance separated. I put an example for better view.

Thanks!

Count Column inside QlikView

Anonymous — Fri, 17 Feb 2012 14:43:40 GMT

Try this

Compliance =Sum(IF(FechaDoc - FechaPO < 0,0,1))

No Compliance = =sum(IF(FechaDoc - FechaPO < 0,1,0))

Regards

Ashok

Count Column inside QlikView

pgalvezt — Fri, 17 Feb 2012 16:49:56 GMT

Excellent!

Many Thanks