topic Re: Remove Null values from Straight Table Chart with Expressions in QlikView

Remove Null values from Straight Table Chart with Expressions

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

I have a straight table chart with 17 dimensions and 4 expressions. The 4 expressions are just SUMs. I am getting one complete row with null values I do not want to see. I checked Suppress When Value Is Null for all Dimension, but that row with null values still display. How can I remove this row.

please help me out for same.

Thanks advance.

Re: Remove Null values from Straight Table Chart with Expressions

neelamsaroha157 — Tue, 07 Aug 2018 20:50:25 GMT

May be you can try it in your expression like -

If( (Your Sum Expression here) >0, (Your Sum Expression here))

Re: Remove Null values from Straight Table Chart with Expressions

satish25 — Wed, 08 Aug 2018 06:05:33 GMT

Hi,

Why don't you change the script in the Data Load Editor using a where Clause

From ...... (qvd)

Where (Your Dimension)<>Null();

Re: Remove Null values from Straight Table Chart with Expressions

thannila — Wed, 08 Aug 2018 06:12:59 GMT

QlikView or QlikSense?

QlikSense-You can able to find one option.

Click on Add-ons->Data Handling->disable the option include null values.

Re: Remove Null values from Straight Table Chart with Expressions

ChennaiahNallani — Wed, 08 Aug 2018 07:09:14 GMT

Re: Remove Null values from Straight Table Chart with Expressions

pooja_prabhu_n — Wed, 08 Aug 2018 07:12:57 GMT

Hi,

=if(len(trim(id))>0,id) as dimension and check suppress null value

Thanks,

Pooja