cancel
Showing results for 
Search instead for 
Did you mean: 

How to hide the blank rows in Webi 4.1

Former Member
0 Kudos


Hi,

Is it possible to hide the empty rows in Webi 4.1 when you check the table property "Avoid duplicate row aggregation"? I tried 'Hide when empty' and hide when following formula is true (isnull), but didn't work. Please see the screen shot. Please let me know if you have any suggestions.

Thank you,

Charvi.

Accepted Solutions (0)

Answers (1)

Answers (1)

jyothirmayee_s
Active Contributor
0 Kudos

Hi,

IS the empty rows comming from backend or do you have any variables in the columns that has null values?.

If it is a varaible then Create : =if(Var1 = 0  or isnull(Var1)) then "Hide" else "Display"

Create a report filter on "Var1" and select "Hide".

Thanks,

Jothi

Former Member
0 Kudos

Hi Jothi,


It is a merge dimension report. So, I do have vafiables created. I tried the above and it is not working as it is not recognising the empty rows even with the formula.

jyothirmayee_s
Active Contributor
0 Kudos

Hi,

Use the variable which is displayed on report and shows empty rows.

Thanks,

Jothi

Former Member
0 Kudos

Apply filter on that dimension/variable

Filter -- Add Filter -- Dimension/Variable -- Not In List (Operator) -- NULL

Former Member
0 Kudos

I did. Not working. I have 4 different variables which are displayed in the report and I want to hide the rows where all 4 variables are blank. Please see below.

Former Member
0 Kudos


Hi Sujitha,

I tried and it still not working. I have applied for 4 different variables and it doesn't work. Please see below.