How to count how many times one dimension is equal or lower than another dimension?

[#1]

Hello,

I´m new qlikview user and I´m having some difficulties to figure out the best solution to do the following:

Eg.:

1. I have the following dimensions "CurrentClassification" "RequiredClassification" and "IssuedClassification".

2. The 3 dimensions shown before are always attached to a process, that is identified by its "Distinct ProcessCode";

2. What I need is to count:

2.1. How many processes I have with the  "IssuedClassification" lower than "RequiredClassification"

2.2. How many processes I have with the  "IssuedClassification" equal than "RequiredClassification"

Thanks in advance!

[Anonymous]

You could set a flag in the load script something like this ?

if ( IssuedClassification < RequiredClassification , 1 , 0 ) as IssuedLessThanRequiredFlag ,

Then in your expression you can just do sum ( IssuedLessThanRequiredFlag )