topic Re: How to create a table showing only 100 largest records in QlikView

How to create a table showing only 100 largest records

Fri, 31 Jan 2014 11:21:05 GMT

Hi,

I want to set up a table displaying only 100 largest transactions in the current week (largest by value)

I have field names such as: Transaction ID, Transaction date, Transaction value and others

I also have a flag that marks "This week" by date

I'm struggling to find the right formula to display only the 100 largest transactions and have them sorted from largest to smallest. I've tried setting that in Dimension Limits - I've set up this filter for every field ("Show only 100 largest values") but it doesn't work.

All suggestions are welcome

Thanks a lot

CaptainP

Re: How to create a table showing only 100 largest records

vikasmahajan — Fri, 31 Jan 2014 11:28:00 GMT

Use have to Use Rank Function to Show Top # of Records.

PFA Sample

Vikas

Re: How to create a table showing only 100 largest records

Gysbert_Wassenaar — Fri, 31 Jan 2014 11:47:19 GMT

If you're using a straight table you can sort by your expression in descending order on the Sort tab and on the Presentation tab enable the option Max Number and set it to 100.

Re: How to create a table showing only 100 largest records

maxgro — Fri, 31 Jan 2014 11:49:08 GMT

you can find a very good doc about showing top performer (in different ways) here

Show Top Performers