can we hide entire row where expression value is null in a straight table

vish123 — Thu, 02 Dec 2021 10:07:14 GMT

Hi Team,

I have a list of columns where we have expression as a column as well in a straight table. some of this expression value is nulls. How can i hide these rows where this expression gives null values.

Re: can we hide entire row where expression value is null in a straight table

Or — Thu, 02 Dec 2021 10:57:20 GMT

You can't directly hide a row just because one (of several) expressions is null, as far as I know.

You can either use the same calculation to nullify all of the other expressions using an if() condition, e.g. if the null expression is Only(FieldName) then your other expressions might be:

Sum(Sales)*if(IsNull(Only(FieldName)),null(),1)

Or you could nullify one of your dimensions and then use "Hide null values" on that dimension.

topic can we hide entire row where expression value is null in a straight table in App Development

can we hide entire row where expression value is null in a straight table

Re: can we hide entire row where expression value is null in a straight table