How to filter a table

[#1]

Hello,

Actually, I have a table with empty cells and I only would like to show a table filled. I think it's impossible to make it with the script and I have to use the expression from the table himself.

Header 1	Header 2	Header 3
Group1
Group2	1	2
Group3	3	4

to

Header 1	Header 2	Header 3
Group2	1	2
Group3	3	4

I hope it is clear and if you need more precision I'll try to put more details.

Regard

[awhitfield]

Hi Kenny,

if it's a 'straight table' then tick 'supress Zero Values' on the presentation tab of the object properties

Andy

[sunny_talwar]

You can use what awhitfield just mentioned above or you can create a calculated dimension like this:

=If(not IsNull(Value1) and not IsNull(Value2), Dim)

this will remove the dimension where Value1 and Value2 are both null.

HTH

Best,

S

[jonathandienst]

Hi

Is this a table box or a straight table. You can suppress nulls by column in a table box.

If it is a straight table, and these fields are all dimension, click the suppress nulls on the dimensions dialog.

If it is a straight table, are the empty cells expressions that return nulls? If so, make sure that suppress zero values is checked. If the cells are empty strings, then you could modify the expressions to return nulls if the result would be an empty string, or create a calculated dimension that returns a null if the expression returns an empty string.

HTH

Jonathan

[Anonymous · Accepted solution]

Go to presentation and check 'omit when value is null' for the respective fields

[ashwanin]

Hi ,

Its possible. You just need to remove blank .

It should be :

Table:

LOAD * INLINE [

    Header_1, Header_2, Header_3

    Group1, ,

    Group2, 1, 2

    Group3, 3, 4

] Where [Header_2] <> '';

[#7]

Hello everyone,

I forgot to mention that's a table box. The table is just an example, the true table is a big one.

Thanks for your help, I made it!

[sunny_talwar]

So then you can use jontydkpi method.

Select Omit Rows Where Field is Null should do the trick for you.

Best,

S