Show row data if expression is not null or equals to 0

[eliran]

Hi all,

I would like to show data in a table but only if a certain expression is larger than 0 or is'nt null.

Using 'Suppress when value is null' is not appropriate of course because it relates to the dimension.

I thought about set analysis, but i will need to do it in all my expressions, any easier way I'm missing out?

Thanks,

Eliran.

[Miguel_Angel_Baeyens · Accepted solution]

Hello Eliran,

You can add in your set analysis the condition that the sum of something is greater than zero, so the aggregation will take place for those values in dimension fields that match that condition, for example, sum of sales for customers who have bought more than 1000 (say any other condition)

Sum({< Customer = {"=Sum(Sales) > 1000"} >} Sales)

But yes, if you want to do this in your chart, you shoul add this to all the expressions in your chart.

Although I don't recommend it, it's possible to use a calculated dimension so only the Customers who have bought more than 1000, but it will take longer to render in the dimension than in the expression.

Hope that makes sense.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[eliran]

Thanks Miguel,

I thought that was the case.

Regards,

Eliran.