Count top 10 from table

[david_pearson]

Hi All

I have a problem I cant quite sort and wonder if anyone can help.

I have a table looking at top ten based on the "cause description". The cause desc has been restricted to display the top 10 in the Qlik table using “Fixed Number”. I can see the correct top 10 however when I apply a count to field "CLAIMNO" I get the wrong total. The total imgetting is actually all the CLAIMNO in the full table rather than just the top 10 displayed.

Any thoughts or suggestion/answers would be great 😏

I had merely applied count(CLAIMNO) initially which obviously hasnt worked.

thanks 

[Anil_Babu_Samineni]

Perhaps this?

count({<[Cause Description] = {"$(=Aggr(Rank(Count(CLAIMNO))<11, [Cause Description]))"}>} CLAIMNO)

[david_pearson]

thanks for the reply. this puts a 0 in all the cells for this column 😞

[Anil_Babu_Samineni]

Perhaps this?

Calculate Dimension:

=IF(Aggr(Rank(Count(CLAIMNO),[Cause Description])<=10,[Cause Description])

Or

Expression:

SUM({<[Cause Description] = {"=Rank(Count(CLAIMNO))<=10"}>}CLAIMNO)

[david_pearson]

it would need to be an expression as im wanting to count the vol of CLAIMNO. the problem with the

"SUM({<[Cause Description] = {"=Rank(Count(CLAIMNO))<=10"}>}CLAIMNO)"

is that the CLAIMNO field is numeric. therefore when i want to count 2 claimno below i would expect the output to be 2 however with your cover i would get 234234 as it sums the fields together.

CLAIMNO

123123

111111

[Anil_Babu_Samineni]

What is returning using that expression?

[david_pearson · Accepted solution]

got it. 

the dimension 

"=IF(Aggr(Rank(SUM(CLAIMNO),4),CAUSE DESCRIPTION)<=10,CAUSE DESCRIPTION)"

then Expression "= Count(CLAIMNO)"

[david_pearson]

@Anil_Babu_Samineni, now that the initial problem has been sorted i have another one. using this new total i want to get a % split for each cause description. i would normally doe count(claimno)/count(total claimno) however this is still taking the overall total (761) of the table rather than the expected 648.

any suggestions?

thanks 

[Anil_Babu_Samineni]

Perhaps this?

count(claimno)/count(total <Description> claimno)

[david_pearson]

unfortunately not. this gives the below as a percentage. it just, for example, doing 177/177 rather than 177/648