Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
sorry it is not working
there is plenty of content available for similar queries
https://community.qlik.com/search.jspa?q=top+10
okay i'll check the above link thanks for the information
=if( AGGR( rank(total count(ProductID)/Count(TOTAL ProductID),0,1), ProductID)<=10, sum(sales))
it is showing somw values as zeros and remaining are nulls
don't know where you are trying this, can you post a screenshot?
% 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)
see attached
check the app i attached!