topic Top 20 in QlikView

Top 20

master_student — Mon, 24 Apr 2017 16:04:13 GMT

Hello Guys,

I would like to create a Top 20 table with those conditions with maximum Nbre de case:

count(if(([Type de cas]='Demande d’information' or [Type de cas]='Réclamation' )and CustCode >= 2 and (Catégorie <> 'Service 1255' and Catégorie <> 'Outil 1255' and Catégorie <> 'Communication interrompue' ),[Code cas]))

The result is now all the rows that has the conditions above

any idea how to display only the Top 20

Thanks

Re: Top 20

Anonymous — Mon, 24 Apr 2017 16:28:34 GMT

if(

rank(total

count(if(([Type de cas]='Demande d’information' or [Type de cas]='Réclamation' )and CustCode >= 2 and

(Catégorie <> 'Service 1255' and Catégorie <> 'Outil 1255' and Catégorie <> 'Communication interrompue'

),[Code cas]))

,4 )<=20

count(if(([Type de cas]='Demande d’information' or [Type de cas]='Réclamation' )and CustCode >= 2 and

(Catégorie <> 'Service 1255' and Catégorie <> 'Outil 1255' and Catégorie <> 'Communication interrompue'

),[Code cas]))

)

Re: Top 20

master_student — Mon, 24 Apr 2017 16:37:03 GMT

it didn't work, here is the result :

Re: Top 20

Anonymous — Mon, 24 Apr 2017 16:39:51 GMT

try first

rank(total

count(if(([Type de cas]='Demande d’information' or [Type de cas]='Réclamation' )and CustCode >= 2 and

(Catégorie <> 'Service 1255' and Catégorie <> 'Outil 1255' and Catégorie <> 'Communication interrompue'

),[Code cas]))

,4 )

I can't test it, because I don't have your data...

Re: Top 20

Anonymous — Mon, 24 Apr 2017 16:51:21 GMT

did you activate supress zero values?

Re: Top 20

master_student — Tue, 25 Apr 2017 07:49:32 GMT

Hello Robin,

I attached my data to my first query. I need the Top 20 rows with max Nbr de Cas.

Thanks for your help