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

    Qlikview Beginner - Please help...

      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.