Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Register for Events and Webinars directly from Qlik Community: http://bit.ly/2Vpnenx
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
Highlighted

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 )