Remove or Hide Null or Missing Value Row From Straight Table Expression

[sona_sa]

Hi Team,

I need to remove the row from straight table object. Which are containing null or zero (0) or missing value in expression.

There is not a single value are available in dimension. Whatever null or zero (0) or missing value are coming, It is coming at the time of calculation or in expression.

I want to remove or hide that row which are containing the same. For ref. please find the attached QVW and XLS

KPI --> Dimension,

1. Expression --> Sum(Value)

2. RAG --> Value G need for all KPI.

Thanks & Regards,

AS

[Shubham_Deshmukh]

Try this : 

https://community.qlik.com/t5/QlikView-App-Development/Suppress-Rows-in-Chart-if-Expression-is-zero/...

[sona_sa]

Hi Shubham, I tried, but not success to implement the same. Can you help me with the same QVW. Regards, AS