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!

       

      Best,

       

      Mohammed