topic Limit Table Rows in QlikView

Limit Table Rows

mariozubieta — Wed, 27 Dec 2017 19:39:32 GMT

Hello,

I was wondering if anyone knows a way, to build a table that would show 3 Rows for every category, based on max amount.

For example, I have 3 category of products, and each category has hundreds of transactions. I need to have a table, with 9 rows, that has the top 10 transactions for each category, order up by Category and then amount.

Here is what I would like to have as a result.

Not that there are plently of ID for each transaction, but I only want to show the 3 with largest amounts.

ID	Category	Amount
32	AA	$4,567
123	AA	$2,345
232	AA	$1,234
2345345	BB	$5,356
6563	BB	$5,123
123234	BB	$4,956
6577	CC	$3,432
34432	CC	$2,456
423	CC	$2,345

Any idea is appreciated.

thanks,

Re: Limit Table Rows

vishsaggi — Wed, 27 Dec 2017 20:31:54 GMT

Did you try using Straight table dimension limits tab and check show largest 3. ?

Re: Limit Table Rows

sergio0592 — Wed, 27 Dec 2017 20:43:14 GMT

Hi,

Maybe you can try with :

=sum({<Id={“=rank (TOTAL <Category> Amount)<=3”}>} Amount)

Re: Limit Table Rows

mariozubieta — Wed, 27 Dec 2017 23:14:41 GMT

This will only bring the 3 biggest, no mater the category

Re: Limit Table Rows

mariozubieta — Wed, 27 Dec 2017 23:16:14 GMT

I tried this, and might need something different on the formula since this didn't work, but I will dig a bit more into this solution, it seams to go on the right direction. thanks for the answer

=sum({<Id={“=rank (TOTAL <Category> Amount)<=3”}>} Amount)

Re: Limit Table Rows

Anil_Babu_Samineni — Thu, 28 Dec 2017 01:07:05 GMT

May be this as Calculated Dimension?

If(Aggr(Rank(Sum(Amount))<=10, Category), Category)

Re: Limit Table Rows

devarasu07 — Thu, 28 Dec 2017 01:39:22 GMT

Hi,

How about this pagination concept.

Paging Implementation for Straight table