topic Re: Supress null values in expression in QlikView

Supress null values in expression

Wed, 06 Jan 2016 06:41:58 GMT

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

Re: Supress null values in expression

PrashantSangle — Wed, 06 Jan 2016 10:02:27 GMT

Hi,

try like

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

Regards

Re: Supress null values in expression

settu_periasamy — Wed, 06 Jan 2016 10:19:23 GMT

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

Re: Supress null values in expression

Peter_Cammaert — Wed, 06 Jan 2016 10:21:13 GMT

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

Re: Supress null values in expression

HirisH_V7 — Wed, 06 Jan 2016 10:21:20 GMT

Hi,

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

and select the option to supress if is null

HTH,

Hirish

Re: Supress null values in expression

Mon, 11 Jan 2016 15:11:25 GMT

can we remove duplicates in dimension

Re: Supress null values in expression

HirisH_V7 — Tue, 12 Jan 2016 04:06:06 GMT

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

Re: Supress null values in expression

amit_saini — Tue, 12 Jan 2016 04:19:17 GMT

John,

Try this:

=if (not isnull(FieldName),FieldName)

Thanks,