Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

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
Highlighted
Specialist II
Specialist II

May be you can try it in your expression like -

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

Highlighted
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();

Highlighted
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.

Highlighted
Creator III
Creator III

Capture.PNG

Highlighted
Creator III
Creator III

Hi,

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

Thanks,

Pooja