diff Graph Vs Tab

master_student — Thu, 16 Nov 2017 15:40:59 GMT

Hello Guys,

I have a table that contains the following dimensions and measures

Here are my expressions :

SLA INTER=num#(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'))

SLA INTER obje=If(

ser ='Bo Facturation' and (

segment= 'VLV'

or segment='LV'

or segment='MV'

or segment='HV'

or segment='HD'

or segment='Premium'

), '2880',

if(

ser ='Bo Facturation' and (

segment= 'LowEndUser'

or segment='HighEndUser'

or segment='Entreprise'

or segment='One to one'

), '1440',

if (

ser ='BO TECKNO ' and (

segment= 'VLV'

or segment='LV'

or segment='MV'

or segment='HV'

or segment='HD'

or segment='Premium'

or segment ='LowEndUser'

or segment ='HighEndUser'

or segment ='Entreprise'

or segment ='One to one'

), '1440'

if (

ser ='DT Support +Fixe + Delivery' and (

segment= 'VLV'

or segment='LV'

or segment='MV'

or segment='HV'

or segment='HD'

or segment='Premium'

), '2880'

if (

ser ='DT Support +Fixe + Delivery' and (

segment= 'LowEndUser'

or segment='HighEndUser'

or segment='Entreprise'

or segment='One to one'

), '1440'

)))))

Hors delais :

if(Column(1)>=Column(2),count(DISTINCT([Code Cas])))

DANS delais : if(Column(1)<Column(2),count(DISTINCT([Code Cas])))

I would like to make a graph number of cases hors delais / dans les delais per services

here is my dimensions calculated :

=Aggr(

If( Sum(TOTAL <[Code Cas], segment,PROVIDER_GRP_ID> num#(Interval(Interval#(SLA_INTERM, 's'), 'm'))) >

If(

ser ='Bo Facturation' and (

segment= 'VLV'

or segment='LV'

or segment='MV'

or segment='HV'

or segment='HD'

or segment='Premium'

), '2880',

if(

ser ='Bo Facturation' and (

segment= 'LowEndUser'

or segment='HighEndUser'

or segment='Entreprise'

or segment='One to one'

), '1440',

if (

ser ='BO TECKNO ' and (

segment= 'VLV'

or segment='LV'

or segment='MV'

or segment='HV'

or segment='HD'

or segment='Premium'

or segment ='LowEndUser'

or segment ='HighEndUser'

or segment ='Entreprise'

or segment ='One to one'

), '1440'

if (

ser ='DT Support +Fixe + Delivery' and (

segment= 'VLV'

or segment='LV'

or segment='MV'

or segment='HV'

or segment='HD'

or segment='Premium'

), '2880'

if (

ser ='DT Support +Fixe + Delivery' and (

segment= 'LowEndUser'

or segment='HighEndUser'

or segment='Entreprise'

or segment='One to one'

), '1440'

)))))

,'Hors Delais'

,'Dans les delais')

,[Code Cas],segment, PROVIDER_GRP_ID)

My expression :

cas traités :

count(DISTINCT

[Code Cas])

My graph

The problem is the number in my graph are not identiqual to the detailed tables, can you please help me to correcte the expressions on my graphs ?

Thanks

topic diff Graph Vs Tab in QlikView

diff Graph Vs Tab