How to remove nulls in the expression from straight table

Anonymous — Thu, 11 Oct 2018 07:47:12 GMT

Dear Qlik,

Iam using straight table and write expression for score for Yellow Category(i,e.>20 and <=50). I am using below expression

=IF((Round(((sum([Continuous Driving without stopping])+sum([Harsh Brakes Count])+sum([Harsh Acceleration count])+sum([Over Speeding Count]))/Sum([Distance in Kms]))*1000)>20 and

Round(((sum([Continuous Driving without stopping])+sum([Harsh Brakes Count])+sum([Harsh Acceleration count])+sum([Over Speeding Count]))/Sum([Distance in Kms]))*1000)<=50),

Round(((sum([Continuous Driving without stopping])+sum([Harsh Brakes Count])+sum([Harsh Acceleration count])+sum([Over Speeding Count]))/Sum([Distance in Kms]))*1000)

)

By using this expression iam getting all values and showing only Yellow category score and using below expression

=IF(ISNULL(IF((Round(((sum([Continuous Driving without stopping])+sum([Harsh Brakes Count])+sum([Harsh Acceleration count])+sum([Over Speeding Count]))/Sum([Distance in Kms]))*1000)>20 and

Round(((sum([Continuous Driving without stopping])+sum([Harsh Brakes Count])+sum([Harsh Acceleration count])+sum([Over Speeding Count]))/Sum([Distance in Kms]))*1000)<=50),

Round(((sum([Continuous Driving without stopping])+sum([Harsh Brakes Count])+sum([Harsh Acceleration count])+sum([Over Speeding Count]))/Sum([Distance in Kms]))*1000)

),0,

IF((Round(((sum([Continuous Driving without stopping])+sum([Harsh Brakes Count])+sum([Harsh Acceleration count])+sum([Over Speeding Count]))/Sum([Distance in Kms]))*1000)>20 and

Round(((sum([Continuous Driving without stopping])+sum([Harsh Brakes Count])+sum([Harsh Acceleration count])+sum([Over Speeding Count]))/Sum([Distance in Kms]))*1000)<=50),

Round(((sum([Continuous Driving without stopping])+sum([Harsh Brakes Count])+sum([Harsh Acceleration count])+sum([Over Speeding Count]))/Sum([Distance in Kms]))*1000)

))

and apply suppress zero value in presentation tab.Now i get null values except yellow category.

Please give me a solution.

Thanks in advanced

Suman.

Re: How to remove nulls in the expression from straight table

swuehl — Thu, 11 Oct 2018 08:01:50 GMT

Option 'Suppress zero values' requires that all expressions return zero or NULL if you want the chart line to not show up.

topic How to remove nulls in the expression from straight table in QlikView

How to remove nulls in the expression from straight table

Re: How to remove nulls in the expression from straight table