topic Remove or Hide Null or Missing Value Row From Straight Table Expression in QlikView

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

sona_sa — Sat, 16 Nov 2024 04:16:30 GMT

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,

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

Shubham_Deshmukh — Tue, 05 Mar 2019 07:00:04 GMT

Try this :

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

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

sona_sa — Tue, 05 Mar 2019 07:46:35 GMT

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