I am working with a dataset that resembles the attached document. The first tab is what the original data resembles. The Second and third tabs are what I am trying to produce on qlik using the pivot table visualisation.
Unfortunately I cannot amend the data-set (does not belong to my organisation) to the optimal format of:
Column 1: trainee name
Column 2: Trainer
Column 3: Course Name
Column 4: Trainee Course Rating
So I am stuck with the original format! Is there anyway of producing pivottables to resemble the 'to Appear qlik 1' and to 'Appear qlik 2' tabs?
For the 'to Appear qlik 2' tab I have been able to do this if I only choose one score (only 'very good' etc...) but cannot seem to have a breakdown per question per trainer.
Please let me know if you have any ideas!. Thank you for you support!