Nulls in rank

[#1]

while Using the rank function in a straight table.   I had taken 3 fields productID, Product Name, and in expression  count(Product ID) as Total Products  and rank column also in expressions.  but i was reloaded successful, and the result is same excatly what i expected ,  so one more column i added Month  the result is showing that some fields are null. the data and the application is attached below

[#2]

sorry it is not working

[vinieme12]

there is plenty of content available for similar queries

https://community.qlik.com/search.jspa?q=top+10

[#4]

okay i'll check the above link thanks for the information

[vinieme12]

=if( AGGR( rank(total count(ProductID)/Count(TOTAL ProductID),0,1), ProductID)<=10, sum(sales))

[#6]

it is showing somw values as zeros and remaining are nulls

[vinieme12]

don't know where you are trying this, can you post a screenshot?

[Kushal_Chawda]

% expression

if(rank(total count({<ProductID,month,ProductName>}ProductID)/Count(TOTAL {<ProductID,month,ProductName>}ProductID),0,1)<=10,

count({<ProductID,month,ProductName>}ProductID)/Count(TOTAL {<ProductID,month,ProductName>}ProductID))*avg(1)

Rank Expression

if(rank(total count({<ProductID,month,ProductName>}ProductID)/Count(TOTAL {<ProductID,month,ProductName>}ProductID),0,1)<=10,

rank(total count({<ProductID,month,ProductName>}ProductID)/Count(TOTAL {<ProductID,month,ProductName>}ProductID),0,1))*avg(1)

[#9]

[vinieme12]

see attached

[vinieme12]

check the app i attached!