topic null values in QlikView

null values

master_student — Mon, 25 Sep 2017 11:12:26 GMT

Hello Guys,

I have a measure that returns null values :

I need to remove null values.

Any idea how ?

Here the expression of SLA Globale : =Interval(Sum(TOTAL <[Code Cas], [Date de commande], SLA_GLOBAL, [Statut Cas]> Interval#(SLA_GLOBAL, 's')), 'm')

Thanks

its_anandrjs — Mon, 25 Sep 2017 11:18:08 GMT

Try simple if

=if( Interval(Sum(TOTAL <[Code Cas], [Date de commande], SLA_GLOBAL, [Statut Cas]> Interval#(SLA_GLOBAL, 's')), 'm') > 0 ,

Interval(Sum(TOTAL <[Code Cas], [Date de commande], SLA_GLOBAL, [Statut Cas]> Interval#(SLA_GLOBAL, 's')), 'm')

)

sunny_talwar — Mon, 25 Sep 2017 11:19:10 GMT

Are you saying that 0 is essentially null? and you want the second row to go away?

master_student — Mon, 25 Sep 2017 11:31:38 GMT

yes

sunny_talwar — Mon, 25 Sep 2017 11:33:22 GMT

There seems to be other columns (which you might not have included in your screenshot)... are those all 0s? or is there a value within some of them?