3 Replies Latest reply: Aug 19, 2011 9:19 AM by Simon Gallantree RSS

    Qlikview Beginner - Please help...

    Simon Gallantree

      Hi all,

       

      I hope everyone is well.

       

      I have a problem that I am hoping someone can help me with.

       

      What I want to do is take a file for a month, say August 11 (1st - 31st) and from here arrange/sort the data by the bill value (£) - this would be my 100% data file.  I then want to remove the bottom 5% and top 5%, giving me a 90% data file.  I then need to replicate this from the 100% file, but removing the bottom 10% and top 10%, giving me an 80% file.  Is there a way I can do this in Qlikview - I'm guessing it is something to do with ranking, but would not know how to code this, assuming I am even correct!

       

      I have attached a file to try and demonstrate what I need to do, but let me know if you need any further information.

       

      Thank you in advance for taking the time to help.

       

      Simon