Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

malradi88
Contributor

Count & If Multi Field Expression

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