Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor III

Top 20

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

Capture.PNG

any idea how to display only the Top 20

Thanks

5 Replies
Highlighted
Valued Contributor III

Re: Top 20

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]))

)

Highlighted
Contributor III

Re: Top 20

it didn't work, here is the result :

Capture.PNG

Highlighted
Valued Contributor III

Re: Top 20

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...

Highlighted
Valued Contributor III

Re: Top 20

did you activate supress zero values?

Highlighted
Contributor III

Re: Top 20

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