topic Re: Show top N rows in table box in QlikView

Show top N rows in table box

Tue, 16 Jun 2015 23:36:44 GMT

Hi There, I'm making a table box that shows rows with top 20 values in the variable called 'Total'.

The table loading query is:

LOAD Specialty as [Product Decile Specialty], 
     One as [Product Decile One], 
     Two as [Product Decile Two], 
     Three as [Product Decile Three], 
     Four as [Product Decile Four], 
     Five as [Product Decile Five], 
     Six as [Product Decile Six], 
     Seven as [Product Decile Seven], 
     Eight as [Product Decile Eight], 
     Nine as [Product Decile Nine], 
     Ten as [Product Decile Ten], 
     Total as [Product Decile Total]
FROM

(ooxml, embedded labels, table is [Product Decile by Specialty]);

How will I be able to do that?

Thanks a million in advance!

Mira

Re: Show top N rows in table box

robert_mika — Wed, 17 Jun 2015 01:08:57 GMT

To store 20 values in variable or to show 20 top in Table box?

Re: Show top N rows in table box

Wed, 17 Jun 2015 06:31:55 GMT

use rank function to display top number according to u r requirement.

eg: Rank(sum(sales))

use dimension limit largest 10

Re: Show top N rows in table box

Anonymous — Wed, 17 Jun 2015 06:43:59 GMT

In table box you can't make any calculations.

Try like this

in sort tab -->sort-->Select Ascending-->expression-max(Field)

Hope it might helps you

Re: Show top N rows in table box

Wed, 17 Jun 2015 15:47:21 GMT

Hi Robert,

To show top 20 in Table box, example:

say the table is long with 100 records:

But what I want to show is, now the table is ranked by the last column "Total", the top 20 rows: Specialty with the Top 20 values in "Total". Like the following:

Re: Show top N rows in table box

Wed, 17 Jun 2015 15:48:15 GMT

Hi Balaji, unfortunately there's no dimension limit tab in the table box properties.

Re: Show top N rows in table box

Wed, 17 Jun 2015 15:49:48 GMT

Hi rgv rand:

This approach looks promising. Is there a function I can use in expression to have the table only show top n rows?

Re: Show top N rows in table box

sinanozdemir — Wed, 17 Jun 2015 15:59:03 GMT

I guess one way to do this is by adding a button to show only Top 20 Values in Total field:

I just copied and pasted from another qvw.

Re: Show top N rows in table box

Chanty4u — Thu, 18 Jun 2015 03:48:14 GMT

use rank(sum(sales)

or in expression in asecnding max(dimension)

hope this helps you

thank you

Suresh