topic IsNull Error in QlikView

IsNull Error

Wed, 25 Nov 2020 16:16:04 GMT

Hi, i was wondering if someone could give me a hand with this. Why do i keep getting error in expression? Thank you!

Re: IsNull Error

sunny_talwar — Mon, 13 Feb 2017 17:50:42 GMT

May be try this:

Max({<ba_userid = {'*'}>} Fecha)

Re: IsNull Error

Nicole-Smith — Mon, 13 Feb 2017 21:49:23 GMT

As an explanation, you can't use a calculation on the left side of a set analysis expression like you currently have. The left side needs to be a field that exists within your data. The right side can be a calculation though. Editing your set analysis to use the same expression on the right side instead of the left would yield this:

Max({<ba_userid = {'=IsNull(ba_userid)=0'}>} Fecha)

Re: IsNull Error

Chanty4u — Tue, 14 Feb 2017 04:59:22 GMT

try below

=Max({<ba_userid ={0],ba_userid ={''}>}Fecha)

Re: IsNull Error

engishfaque — Tue, 14 Feb 2017 06:28:26 GMT

Hi Elina,

Here is the expressions for null value,

1. Retrieve Max Fecha where ba_userid is equal to Null

=Max({<ba_userid = {'=Null()'}>} Fecha)

2. Retrieve Max Fecha where ba_userid is not equal to Null

=Max({<ba_userid -= {'=Null()'}>} Fecha)

Kind regards,

Ishfaque Ahmed

Re: IsNull Error

sdmech81 — Tue, 14 Feb 2017 09:03:25 GMT

Try this aswell:

1. Retrieve Max Fecha where ba_userid is equal to Null

=Max({<len(ba_userid)=0>} Fecha)

2. Retrieve Max Fecha where ba_userid is not equal to Null

=Max({<len(ba_userid)-=0>} Fecha)

Sachin

Re: IsNull Error

vardhancse — Tue, 14 Feb 2017 09:05:43 GMT

The IsNull function tests if the value of an expression is NULL and if so, returns -1 (True), otherwise 0 (False).