Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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!

1 Reply
Anonymous
Not applicable
Author

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 )