topic Re: exclude Cases in QlikView

exclude Cases

master_student — Thu, 02 Nov 2017 08:35:08 GMT

Hello Guys,

I have a table that contains cases , every case_id has many status like this :

My goal is to keep cases_id that has minimum one of this status

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

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

OR [Statut Cas]='Fermé activation'

OR [Statut Cas]='Fermé BO'

OR [Statut Cas]='Fermé DT'

OR [Statut Cas]='Fermé Rétention'

OR [Statut Cas]='Fermé Rétention Client Perdu'

OR [Statut Cas]='Fermé Rétention Client Retenu'

+ the other status of the case

The output would be :

The expression of the SLA Inter is =Interval(Sum(TOTAL <[Code Cas], [Date création], [Statut Cas], PROVIDER_GRP_ID> Interval#(SLA_INTERM, 's')), 'm')

Thanks a lot

Re: exclude Cases

sunny_talwar — Thu, 02 Nov 2017 08:39:17 GMT

May be this

=Interval(Sum({<[Code Cas] = p({<[Statut Cas] = {'Fermé crédit', 'Fermé-remboursé', 'Fermé activation', 'Fermé BO', 'Fermé DT', 'Fermé Rétention', 'Fermé Rétention Client Perdu', 'Fermé Rétention Client Retenu'}>})>}TOTAL <[Code Cas], [Date création], [Statut Cas], PROVIDER_GRP_ID> Interval#(SLA_INTERM, 's')), 'm')

Re: exclude Cases

master_student — Thu, 02 Nov 2017 08:45:36 GMT

Thanks Sunny,

your expression is correct, but the problem is that so many cases still appear and they don't contain one of the status above :

Re: exclude Cases

sunny_talwar — Thu, 02 Nov 2017 08:49:38 GMT

Could a case repeat within different PROVIDER_GRP_ID? or is the case a unique identifier?

Re: exclude Cases

master_student — Thu, 02 Nov 2017 08:56:24 GMT

every case has a unique identifier

Re: exclude Cases

sunny_talwar — Thu, 02 Nov 2017 09:02:22 GMT

may be it does have one of the listed status with 0 SLA_INTERM value to it?

Re: exclude Cases

master_student — Thu, 02 Nov 2017 09:56:30 GMT

Yes Sunny, what you said is correct but how to appear this status even with 0 value

Re: exclude Cases

master_student — Thu, 02 Nov 2017 09:58:05 GMT

I uncheked supress null values in the presenation TAB and 0 values appear

Thanks Sunny