0 Replies Latest reply: Aug 12, 2013 9:05 AM by Johan Govers RSS

    Conditional count of changes

      Hi all,

       

      While constructing a application I encountered a issue for which I have created the following example:

       

      ScreenShot248.jpg

      Note: Excel file is attached

       

      Following rules apply:                                                

      -date revision > date existing ID

      -Valid revision is a increase higher than A of revision for a ID

      -Revisor and approver may never be the same                                                         

       

      Target:

      Count of  increase of revisions higher than A per ID where the status is approved and express the outcome per owner.                           

        

      Expected outcome:
      Group 1=0 AA2087 revision B is working: therefore no count)

      Group 2=3 (counted: AA2678  A to B, B to C, C to D)

      Group 3=2 (counted: AA2345 A to B, B to C)          

       

      I want to display these values in a chart/table.

       

       

      I am not an experienced with Qlikview. I hope you will be able to help me getting into the right direction.

       

       

      Thanks in advance!

       

       

      Regards,

       

       

      Johan