Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
sumanta1234
Not applicable

How to get Top 25 records

How to get top 25 records in the straight table.pic1.PNG

10 Replies
Highlighted
tresesco
Not applicable

Re: How to get Top 25 records

Have you tried Dimension Limits (tab) ?
sumanta1234
Not applicable

Re: How to get Top 25 records

Used Fixed value 25 but did not work.

tresesco
Not applicable

Re: How to get Top 25 records

Could you share your sample app?
pradosh_thakur
Not applicable

Re: How to get Top 25 records

what if you change your expression to below

Let's say your expression is sum(Sales)

you change it to

Sum(Sales) * avg({<[Customer Code]={"=rowno(total) <26"}>}1)
Learning never stops.
pradosh_thakur
Not applicable

Re: How to get Top 25 records

Then off course 

Addons-> data handling-> uncheck include zero values

Learning never stops.
jontydkpi
Not applicable

Re: How to get Top 25 records

>>Used Fixed value 25 but did not work.

Please be more specific if you want useful assistance.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
sumanta1234
Not applicable

Re: How to get Top 25 records

I have applied your expression but not get the proper result.

Capture1.PNG

pradosh_thakur
Not applicable

Re: How to get Top 25 records

If your customer code is unique you will get proper result. What is the difference , may be you can post a sample app to have a look and help you out.
Learning never stops.
pradosh_thakur
Not applicable

Re: How to get Top 25 records

Try this

new expresion ------- >     If(Rowno(total) <26, your_expression,null()) 

 

supress zero under addons-> datahandling

 

Learning never stops.