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:




      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!