0 Replies Latest reply: Aug 10, 2016 7:44 AM by Conor O'Kane RSS

    Decile Analysis

      I am looking to create a dashboard that looks like the following


      decile qlik question.png

      The sheet would have a field to select a person. What I would then want to create is:


      1. A table that displays the decile points for all people in that company over two measures (Average Customer Satisfaction, Average NPS)

      2. A (pivot?) table that states the decile that the selected person is in for both of these measure.


      I attach here the data that I am working off and also the mocked-up output shown in the picture above.


      Please let me know if you could be of help.