Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2014-01-31 06:21 AM

How to create a table showing only 100 largest records

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

282 Views
0 Likes
3 Replies
vikasmahajan
MVP
MVP
‎2014-01-31 06:28 AM

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

PFA Sample

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
top 5 CHART.qvw
178 Views
0 Likes
Gysbert_Wassenaar
MVP
MVP
‎2014-01-31 06:47 AM

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.


talk is cheap, supply exceeds demand
178 Views
maxgro
MVP
MVP
‎2014-01-31 06:49 AM

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

Show Top Performers

178 Views