topic isnull function in QlikView

isnull function

Anonymous — Sun, 19 Jul 2015 14:00:29 GMT

Hi,

I need to display true or false depending on the result of isnull function.

It displays 'true' but it doesn't display 'false'.

See the file attached.

Could you please help?

Thank you in advance,

Larisa

Re: isnull function

swuehl — Sun, 19 Jul 2015 14:07:40 GMT

The dashes in the pivot table don't stand for NULL, but missing. See attached.

Re: isnull function

qlikviewwizard — Sun, 19 Jul 2015 14:18:21 GMT

Hi Check this.

Re: isnull function

Anonymous — Sun, 19 Jul 2015 14:31:09 GMT

Hi swuel,

I meant to say that normally an 'if-function' allows to set any if-true-expression and any if-false-expression.

If (Expression, if-true-expression, if-false-expression)

But if I use an 'isnull-function' as an argument of an 'if-function' then if-false-expression doesn't work. And I want to make it work. Is it possible somehow?

Larisa

Re: isnull function

swuehl — Sun, 19 Jul 2015 14:49:17 GMT

I assume you want to see 'false' returned by your expression at the locations you currently see the dashes in your pivot table.

I tried to explain that your expression won't even be evaluated for these dimension value combinations, that's called 'missing'.

If you unpivot the horizontal dimension Advertiser, these missing combinations won't show up.

Re: isnull function

Anonymous — Sun, 19 Jul 2015 14:54:40 GMT

I see. Thank you!