topic Hiding or Suppressing the Null / Empty Values in QlikView

Hiding or Suppressing the Null / Empty Values

khigaurav999 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Folks,

I am new to QlikView. I have following straight table object. In below table, how can I hide/suppress rows for which WBS Element and PRJ_ID are empty?

I tried doing it thru options under presentation properties but no success. please help.

Thanks,

Gaurav

Re: Hiding or Suppressing the Null / Empty Values

zhadrakas — Thu, 03 Aug 2017 08:05:04 GMT

Hello Gaurav,

in dimenions tab you will find a Checkbox "suppress if value is null"

tick that box for your Dimension PO Number. That way you will get rid of the last row.

To exclude to first row also, you could Change your dimension

if(len(trim(PRJ_ID))>0, PO Number)

regards

tim

Re: Hiding or Suppressing the Null / Empty Values

ramasaisaksoft — Thu, 03 Aug 2017 10:37:58 GMT

why you didn't check the Suppress Missing values Check box in Expression level,please check that also for each expression individually.

In Chart properties > Presentation tab > Check the suppress zero-values

Please check the check box.

then these entire row will hide.

if not please share your .qvw file with dummy data so that our folks will help u ASAP.

Re: Hiding or Suppressing the Null / Empty Values

balar025 — Thu, 03 Aug 2017 11:13:11 GMT

Hi,

in straight table dimension it self you can check suppress null for individual dimension.