Expression - Only function with null if condition

[suvechha_b]

Hi All,

I am using a table - with dimension Service Id,Risk Category Adjusted Score, RISK_MODEL_EXEN_END_DT,

I have to show the table report when [Risk Model End Execution Id] is NULL.

So, I used the expression -

=Only({$<=if(IsNULL([Risk Model End Execution Id]),'NULL','NOTNULL') >}[Risk Model End Execution Id]

but giving me error in expression-

Please kindly assist.

Thanks

[tresesco]

You might not need only() here. What if you just try:

if(IsNULL([Risk Model End Execution Id]),'NULL','NOTNULL')

[suvechha_b]

Hi Tresesco,

I use the expression but it is showing both NULL and NOTNULL.

My requirement is to show only the NULL in my report.

Thanks in advance.

[tresesco]

Then:

if(IsNULL([Risk Model End Execution Id]),'NULL')

Now if you want to hide all the non null rows, you have to play with suppress option and other expression handling as well.

[suvechha_b]

Hi,

How to hide the not null values

[tresesco]

Since you have many expressions, one can have null others not. So this hiding depends on that logic - when do you want to hide the row, when all rows are null/not null, or only this column is null/not null. You have to adjust your other expressions as well accordingly to produce null/not nulls and then you can hide a row while all expressions are having nulls. Otherwise, you have to filter your dimension based on condition/expression. 

There would be many posts regarding this, please search for detailed help.

[suvechha_b]

Hi there ,

I have use a straight table -

two dimension - [Service Id] and [Risk Feature Score].

and a table measure : 

if(IsNULL([Risk Model End Execution Id]),'NULL') 

to get the below report.

Now I want to show only with NULL values.