Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Remove Null values from Straight Table Chart with Expressions

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.

5 Replies
neelamsaroha157
Specialist II
Specialist II

May be you can try it in your expression like -

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

satish25
Contributor III
Contributor III

Hi,

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

From ...... (qvd)

Where (Your Dimension)<>Null();

thannila
Creator
Creator

QlikView or QlikSense?

QlikSense-You can able to find one option.

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

ChennaiahNallani
Creator III
Creator III

Capture.PNG

pooja_prabhu_n
Creator III
Creator III

Hi,

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

Thanks,

Pooja