1 Reply Latest reply: Nov 27, 2014 11:50 AM by Bill Markham RSS

    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!