Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Go to presentation and check 'omit when value is null' for the respective fields
Hi Kenny,
if it's a 'straight table' then tick 'supress Zero Values' on the presentation tab of the object properties
Andy
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
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
Go to presentation and check 'omit when value is null' for the respective fields
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] <> '';
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!
So then you can use jontydkpi method.
Select Omit Rows Where Field is Null should do the trick for you.
Best,
S