Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

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

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 )