Discussion Board for collaboration related to Creating Analytics for QlikView.
I´m new qlikview user and I´m having some difficulties to figure out the best solution to do the following:
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!
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 )