Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
master_student
Creator III
Creator III

100%

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 :

Capture.JPG

3 Replies
sunny_talwar

What is your expression and what are you two dimensions?

master_student
Creator III
Creator III
Author

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 ='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 ='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)

sunny_talwar

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