topic Re: Avoiding Nulls in a Column in QlikView

Avoiding Nulls in a Column

Anonymous — Tue, 12 Jul 2016 21:09:54 GMT

Please find the attached application , I am trying to avoid Nulls in the Feature column , I have use len and trim in the script for RUM Group and RUM Feature columns(Service Time Series RUM Tab in Script) , but still I see Nulls values in the Group : Feature filter.

Can someone please help me in avoiding the null values in Feature column both from tables and filters.

Thank you!

Re: Avoiding Nulls in a Column

alexpanjhc — Tue, 12 Jul 2016 21:34:36 GMT

It sounds like you do not want to load in to the null at all, so in pre load, can you do

SQL SELECT *

FROM "Operational Xcellence: RUM Time Series bj32atvjv"

where len("Group Mapping")>0 and len("Feature Mapping")>0;

Re: Avoiding Nulls in a Column

Anonymous — Tue, 12 Jul 2016 21:53:24 GMT

Hi,

You can also right click in your table, click on properties, on Dimension tab select RUM Feature and check the box 'Suppress when value is null'. After that, click on OK.

Best Regards,