100%

master_student — Thu, 18 Jan 2018 20:08:47 GMT

Hello Guys

I have a % graph to get the 100% you should add all the bar by dimension %, i need to get all 100% IN evry dimensio

any idea how

here is my graph :

Re: 100%

sunny_talwar — Thu, 18 Jan 2018 20:10:03 GMT

What is your expression and what are you two dimensions?

Re: 100%

master_student — Thu, 18 Jan 2018 20:48:21 GMT

My dimensions :

services :

if( Match(PROVIDER_GRP_ID, 'MAILING', 'OCMAILING', 'RECL_HV', 'RECL_LV', 'RECL_MV','RÉCSOCIALM', 'SELF_CARE', 'UDRÉSIDEN', 'URCORP', 'URMOB2C', 'URVASB2B', 'URVASRÉSID' ),'BO Teckno ' ,

if(Match(PROVIDER_GRP_ID, 'TECH', 'DTTECHFIXE','B2B_DELIV','SUPPORTB2B'),'DT Support +Fixe + Delivery'

if(Match(PROVIDER_GRP_ID, 'RECLFACT','FACT_BUSIN','FACT_RÉSID','FACT_CGC','FACT_FIXE'),'Bo Facturation' ,

if(Match(PROVIDER_GRP_ID, 'RÉCSOCIALF','FIXEB2B','INTERB2C','RECFIXEB2B', 'FIXEB2C','SUPP_MAIL'),'Bo Fixe' ,

))))

=Aggr(

If( Sum(TOTAL <[Code Cas], [Concern. MSISDN], SLA_GLOBAL, segment, PROVIDER_GRP_ID,SLA_INTERM>

num#(Interval(Interval#(SLA_INTERM, 's'), 'm'))) >

If(

ser ='Bo Facturation' and [Criticité cas ]='Non Critique' and (

segment= 'VLV'

or segment='LV'

or segment='MV'

or segment='HV'

or segment='HD'

or segment='Premium'

), 2880,

if(

ser ='Bo Facturation' and [Criticité cas ]='Non Critique' and (

segment= 'LowEndUser'

or segment='HighEndUser'

or segment='Entreprise'

or segment='One to one'

), 1440,

If(

ser ='Bo Facturation' and [Criticité cas ]='Critique' 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 ='BO TECKNO ' and [Criticité cas ]='Non Critique' or [Criticité cas ]='Critique' 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 [Criticité cas ]='Non Critique' 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 [Criticité cas ]='Non Critique' and (

segment= 'LowEndUser'

or segment='HighEndUser'

or segment='Entreprise'

or segment='One to one'

),1440

if (

ser ='DT Support +Fixe + Delivery' and [Criticité cas ]='Critique' and (

segment= 'VLV'

or segment='LV'

or segment='MV'

or segment='HV'

or segment='HD'

or segment='Premium'

), '1440'

if (

ser ='DT Support +Fixe + Delivery' and [Criticité cas ]='Critique' and (

segment= 'LowEndUser'

or segment='HighEndUser'

or segment='Entreprise'

or segment='One to one'

),1440

if (

ser ='BO TECKNO ' and [Criticité cas ]='Critique' 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

))))))))

)

,'Hors Delais','dans les delais')

,[Code Cas], [Concern. MSISDN],[Date de création], SLA_GLOBAL, segment,PROVIDER_GRP_ID,SLA_INTERM)

my expression : count(CASE_ID)

Re: 100%

sunny_talwar — Sun, 21 Jan 2018 00:50:55 GMT

Might be easier to look at this if you can share a sample?

topic Re: 100% in QlikView

100%

Re: 100%

Re: 100%

Re: 100%