Count Column inside QlikView

[pgalvezt]

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!

[Anonymous · Accepted solution]

Hi

     Try this

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

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

Regards

Ashok

[pgalvezt]

Excellent!

Many Thanks