Supress null values in expression

[#1]

Hi

I have an expression previously in my straight table and now i have added a dimension and a new expression to the same straight table which resulted null values in the previous expression

Can we supress or remove null values in expression level

Regards

[PrashantSangle]

Hi,

try like

Sum({<FieldName={"=not isnull(FieldName)"}>}Sales)

Regards

[settu_periasamy]

Or

=Sum({<FileldName= {"=Len(Trim(FieldName)) > 0"}>}Sales)

[Peter_Cammaert]

You want to remove all rows that have a NULL value in the first (original) expression column?

Then change your second expression into something like:

=IF (NOT IsNull([LabelOfOriginalExpression]), SecondExpression)

Replace the two words in italics with what you have in your table.

With this trick, we force Expression2 to NULL if the outcome of Expression1 proves to be NULL. NULLs in all expression will cause a row to be suppressed. That is if you didn't change the Show NULL value setting in your table properties.

Best,

Peter

[HirisH_V7]

Hi,

if(IsNull(expresion, Null(), Dimension)

and select the option to supress if is null

HTH,

Hirish

[#6]

can we remove duplicates in dimension

[HirisH_V7]

Hi,

You can remove all the null values  like this at back end itself,

LOAD MainKey,
    IF(IsNull(Data),0, Data) as MainData ,
FROM
[$(vExcelPath)\1.xlsx]
(ooxml, embedded labels, table is 1) Where MainKey<>Null();

Hope this Helps,

Hirish

[amit_saini]

John,

Try this:

=if (not isnull(FieldName),FieldName)

Thanks,

AS