expression

[master_student]

Hello Guys,

I have an expression that returns null values

I would like to delete the null rows

how can I do this

Here is my expression :

=Aggr(

If( Sum(

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

,

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

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

Thanks a lot

[sunny_talwar]

Is 'Suppress Zero Value' on the presentation tab checked or not? If it is not, then make sure that it is checked.

[master_student]

yes Sunny its checked, see bellow :

Any other suggestions please :

[pradosh_thakur]

try adding the expression in the dimension and hide it using the presentation tab and suppress null values. It may affect your performance as you have so many nested if in your expression . give it a try and let me know.

regards

Pradosh

[sunny_talwar]

Do you happen to have more than one expression in your chart?

[stevedark · Accepted solution]

Hi Wieme,

My guess is that you have more elements in your AGGR parameters than you have in dimensions in your chart, meaning that there is more than one possible answer for that row.

You should always have an aggregation (e.g. Sum, Avg, Max, Min) around an Aggr statement when used as an expression.  Adding one of these will most likely fix the issue.

This may not give you the answer you want though, if not, ensure that all of these are in your dimensions:

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

Hopefully that will solve it.

Steve