Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
Thank you this help me to fix the problem