2 Replies Latest reply: Jul 13, 2017 10:48 AM by Mohammed Al Radi RSS

    Pivot Table Formatting Queries

    Mohammed Al Radi

      Dear Qlik Community,


      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!