0 Replies Latest reply: Sep 8, 2017 1:52 PM by Mohammed Al Radi RSS

    Count & If Multi Field Expression

    Mohammed Al Radi

      Dear Qlik Community,

       

      I hope this finds you well. I am currently working on a data set that consists of 11 fields:

       

      Trainee

       

      Pre Training 1

      Post Training1

       

      Pre Training 2

      Post Training 2

       

      Pre Training 3

      Post Training 3


      Post Training 4

      Post Training 4


      Post Training 5

      Post Training 5


      I am trying to create an expression that instructs Qlik to calculate: The number of Trainees who who improve on at least 1 of the 5 trainings. I have tried a few combinations with set expression but can't seem to get a result. This is the general format that I have been experimenting with, but no luck....any assistance would be much appreciated! I attached the dataset as well if that is helpful.



      Count({$<[Post1]= {' >Sum ([Pre1])'}>+<[Post2]= {' >Sum ([Pre2])'}> }Distinct [Name])


      Thank you!

       

      Best,

       

      Mohammed