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.