Limit of records using a pivote table

[Emmanuelle__Bustos]

Hello,

I need to create a pivot table and have a list of aprox 1,000 records, and I would like to limit the customers to a top 100 list. The option to check the Max Number is available in the Straight Table but not in a Pivot Table. Anyone has the way to limit this?

i found this discussion with apparently the answer but the link to the forum doesn't exist, can somebody help me?

http://community.qlik.com/message/3925#3925

[#2 · Accepted solution]

SV:top 100 of smallest amount

hi Emmanuelle

May br you can use the Rank function in a if condition ...like

if(Rank(if(sales>0,-sales))<100,Sales) ...

May be this helps

http://community.qlik.com/message/109811#109811

thanks

Meher

[Emmanuelle__Bustos]

Thank you this help me to fix the problem