topic Re: expression in QlikView

expression

master_student — Tue, 26 Dec 2017 11:02:13 GMT

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

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

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

Thanks a lot

Re: expression

sunny_talwar — Tue, 26 Dec 2017 17:53:04 GMT

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

Re: expression

master_student — Wed, 27 Dec 2017 08:23:12 GMT

yes Sunny its checked, see bellow :

Any other suggestions please :

Re: expression

pradosh_thakur — Wed, 27 Dec 2017 10:32:13 GMT

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

Re: expression

sunny_talwar — Wed, 27 Dec 2017 12:07:50 GMT

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

Re: expression

stevedark — Fri, 29 Dec 2017 13:59:34 GMT

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