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.
