topic Expression - suppress when null in QlikView

Expression - suppress when null

Fri, 22 Apr 2011 12:30:36 GMT

Hi,

Is it possible to suppress values when null for expressions the same way you can do it for dimensions?

Thanks in advance

Expression - suppress when null

Fri, 22 Apr 2011 13:14:45 GMT

Yes It is very much possible in dimesion too.

Same as expression you can surpress null value in dimension also.

Expression - suppress when null

Fri, 22 Apr 2011 13:37:39 GMT

Thanks for the reply.

Do you know how to? Is there a tickbox or anything because I can't seem to find one

Expression - suppress when null

Fri, 22 Apr 2011 13:52:01 GMT

Please find the attached snapshot and do the same in streight table or pivot ........

Please mark as answered if problem solved.

Regards,

Dushyant

Expression - suppress when null

Fri, 22 Apr 2011 14:20:58 GMT

Thanks Dushyant,

The screenshot you sent is to suppress null values for dimensions. I'm looking for how to suppress null values for expressions.

What I am working on is a pivot table and my expression works out the total revenue. What I want to do is when say the month of May (dimension) has no revenue (expression). It will remove the whole row.

Expression - suppress when null

Fri, 22 Apr 2011 15:49:31 GMT

it is not the perfact solution but it will work.

Use the expression simmilar to below in presentation tab instead of number you insert to limit the number of row displayed.

=====================

sum(if(isnull(<Expression>),1,0)

=====================

i hope this will help....

it is not gud for large data set.

its a temperory solution.

Regards,

Dixit

SV:Re: Expression - suppress when null

ToniKautto — Fri, 22 Apr 2011 15:52:42 GMT

One option to suppress the rows where you have null in an expression is to add a calculated dimension.

For example;
=if(not IsNull(F2), F1)

Where F1 is the dimension field and F2 is the expression.

SV:Re: Expression - suppress when null

Fri, 22 Apr 2011 16:09:11 GMT

Hello Tony,

What happen if your expression contain same field whatever you have used in dimension?

It is for my knowledge. Because right now i am not able to test that one.

Thanks,

Dixit

SV:Re: SV:Re: Expression - suppress when null

ToniKautto — Fri, 22 Apr 2011 16:53:19 GMT

Calculated dimension can have a quite bad impact on performance, so you really do not want to have too heavy calculations in the dimension.

What is the reason to hide rows with null expression results? Is the null a result of data model not being perfect?