Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
cliff_clayman
Creator II
Creator II

Remove Null values from Straight Table Chart with Expressions

I have a straight table chart with 4 dimensions and 3 expressions.  The 3 expressions are just SUMs.  I am getting null values in one of my fields that I do not want to see.  I checked Suppress When Value Is Null for that Dimension, but the null values still display.  How can I remove those null values?

1 Solution

Accepted Solutions
sunny_talwar

For the Division dimension can you try a calculated dimension....

If(Len(Trim(Division)) > 0, Division)

and then use 'Suppress When Value is Null' option on the dimension tab...

View solution in original post

3 Replies
trdandamudi
Master II
Master II

Can you please share a sample so that we can take a look.

cliff_clayman
Creator II
Creator II
Author

DivisionUnitCodeAgeYTD Avg MoYTD Avg $YTD Avg Items
112343011000100
245676022000200
378909033000300
112343011500150
245676022500250
378909033500350
112343011250125
245676022250225
378909033250325
A112343011000100
A245676022000200
A378909033000300
B112343011500150
B245676022500250
B378909033500350
C112343011250125
C245676022250225
C378909033250325
sunny_talwar

For the Division dimension can you try a calculated dimension....

If(Len(Trim(Division)) > 0, Division)

and then use 'Suppress When Value is Null' option on the dimension tab...