How to remove nulls in the expression from straight table
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.
