Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Nulls in rank

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

Capture.JPG

21 Replies
qlikview979
Specialist
Specialist

Hi,

Here it is showing for only April month,

can you please share the sample app.

Not applicable
Author

okay definitely

Kushal_Chawda

try this expression

rank(total count(ProductID)/Count(TOTAL ProductID),0,1)

Not applicable
Author

yeah its working but  if we click on anything it is not showing the rank in serial.  can you please help me

Kushal_Chawda

So if you select any product or month, then % & Rank which is calculated should not change?

Not applicable
Author

suppose if we want to check the top 10 by rank wise if we click on anything % should not be changed and the rank should be change by top 10 wise . Then what i have to do?  can you please say

Kushal_Chawda

I didn't get this. Can you give one example?

vinieme12
Champion III
Champion III

Try below

=AGGR(rank(total count({1}ProductID)/Count({1}TOTAL ProductID),0,1),ProductID)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Not applicable
Author

suppose i want to check top 10 ranks in a year 2008.