Auto Hide rowns based on condition

[raju_salmon]

Hi,

I have a straight table with many dimensions and expression.

There is expression called Sum(Responses), if this values is zero, then i need to hide entire row irrespective of other expression values? I have tried many ways but no use.

Can anyone help me what to do?

[#2]

Go to Properties-> settings for selected Dimension -> tick on checkbox Suppress when value is null

It may work for you

[sunny_talwar]

You can use an if statement for all your expressions to force them to be null when Sum(Responses) = 0. So something like this

If(Sum(Responses) > 0, Expression1)

If(Sum(Responses) > 0, Expression2)

...

and so on...

[lawrance]

RE: Auto Hide Rows based on the condition

Hi Raju,

Please try this below condition.

You can use set analysis for that conditional statement.

For Example,

=SUM({Responses ={'> 0'}>} Expression}

Thanks,

Lawrance A

[raju_salmon]

Thanks Sunny, do i need to keep condition for all expressions to exclude whole row? or can we set any condition for dimension?

[sunny_talwar · Accepted solution]

You can do this for your dimension also....

Aggr(If(Sum(Responses) > 0, YourDimensionName, ListAllDimensionsHere)

Few things:

1) You just need to do this for one dimension

2) List all the dimensions within the Aggr function

3) Remember to check 'Suppress When Value Is Null' on the dimension tab.

[raju_salmon]

Thanks Sunny, i will implement and mark it as correct response.

[raju_salmon]

Hi Sunny,

I have followed the below steps and not working. Can you please see where i have gone wrong.

I have two dimensions

Date_Group (Drill down group)

DayName

Already dayname has one condition where it display only when date is selected.

Now i have kept a condition for Date_Group condition as below

Aggr(If(Sum(Responses) > 0, Date_Group, DayName)

and i checked 'Suppress When Value Is Null'.

In above response you have mentioned below

Aggr(If(Sum(Responses) > 0, YourDimensionName, ListAllDimensionsHere)

In above statement May i know what is "YourDimensionName"? and ListAllDimensionsHere?

Thanks Sunny.

[raju_salmon]

Got it Sunny, i have taken calculated dimension.