filtr Qlik

[master_student]

Hello Guys,

I need your help

a case (code cas ) may have many status, I need to keep cases that have these status  and to keep the other status of cases that have and end status

[Statut Cas]='Fermé crédit'

OR [Statut Cas]='Fermé-remboursé'

OR [Statut Cas]='Fermé activation'

OR [Statut Cas]='Fermé BO'

The desired output is :

[cristinapo]

Hi Wiem, can you please elaborate on the second part where you say "to keep the other status of cases that have and end status". Not sure what you mean.

From the desired output that you pasted, I see that you also have case 137282256 which doesn't have any of the statuses you listed in

[Statut Cas]='Fermé crédit'

OR [Statut Cas]='Fermé-remboursé'

OR [Statut Cas]='Fermé activation'

OR [Statut Cas]='Fermé BO'

[Aurelien_Martinez]

Hi,

You can try a expression like this :

If(WildMatch(Concat(distinct TOTAL <[Code Cas]> [Statut Cas]), 'Fermé*'), Count())