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

    Decile Analysis

    Conor O'Kane

      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.

       

      Conor