values comparaison

master_student — Sun, 19 Nov 2017 10:32:37 GMT

Hello Guys,

I have a table that compares two values and display dans les delais or Hors delais according to the result of comparaison

heres my caculated dimension

=Aggr(

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

if([Criticité cas ] = 'Non Critique' and (segment = 'VLV' or segment = 'LV'

or segment = 'MV'

or segment = 'HD'

or segment = 'HV'

or segment = 'Premium'

),4320,

if([Criticité cas ] = 'Non Critique' and (segment ='LowEndUser' or segment = 'HighEndUser'

or segment = 'Entreprise'

),2880,

if([Criticité cas ] = 'Non Critique' and (segment ='One to one'

),1440

if([Criticité cas ] ='Critique' and (segment = 'VLV' or segment = 'LV'

or segment = 'MV'

or segment = 'HD'

or segment = 'HV'

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])

expression

SLA Globale :

num#(Interval(Interval#(SLA_GLOBAL, 's'), 'm'))

SLA objective :

if([Criticité cas ] = 'Non Critique' and (segment = 'VLV' or segment = 'LV'

or segment = 'MV'

or segment = 'HD'

or segment = 'HV'

or segment = 'Premium'

),'4320' ,

if([Criticité cas ] = 'Non Critique' and (segment ='LowEndUser' or segment = 'HighEndUser'

or segment = 'Entreprise'

),'2880',

if([Criticité cas ] = 'Non Critique' and (segment ='One to one'

),'1440'

if([Criticité cas ] ='Critique' and (segment = 'VLV' or segment = 'LV'

or segment = 'MV'

or segment = 'HD'

or segment = 'HV'

or segment = 'Premium' or

segment ='LowEndUser' or segment = 'HighEndUser'

or segment = 'Entreprise'

Or segment='one to one')

,'1440'

))))

Re: values comparaison

Anil_Babu_Samineni — Mon, 20 Nov 2017 03:20:41 GMT

What is the issue?

topic values comparaison in QlikView

values comparaison

Re: values comparaison