topic Re: IF NULL THEN... syntax in QlikView

IF NULL THEN... syntax

anonymous1 — Sat, 16 Nov 2024 03:04:14 GMT

hi guys,

im wondering if you can help me, i believe i may have my syntax wrong for this 'if...null' expression.

im creating a list box, i want it to have 2 options: Exists or Does Not Exist:

=IF (IsNull([DATE], 'Does Not Exist', 'Exists')

basically, in the data, if the date is null then the inventory doesn't exist, otherwise it does exist. this statement does not work. anyone have any ideas?

regards

Re: IF NULL THEN... syntax

bharathadde — Mon, 08 Jul 2019 15:38:26 GMT

I think you forgot to include bracket after Date

=IF (IsNull([DATE]), 'Does Not Exist', 'Exists')

if above doesn't work then use below

=IF (Len([DATE])>0, 'Exists', 'Does Not Exist')

Re: IF NULL THEN... syntax

trdandamudi — Mon, 08 Jul 2019 15:39:32 GMT

Can you please give a try on the below expression and see if it works:

=IF (Len([DATE])>0, 'Exists' , 'Does Not Exist')

Re: IF NULL THEN... syntax

acsaggar — Mon, 08 Jul 2019 15:44:57 GMT

Hi Anonymous 1
What output are you getting? You should be able to do this in a list box.
Alternatively, you can try putting this expression in the script and aliasing it
e.g.
if(isnull([Field]),'Does not exist', 'Exists') as Existence

then create a list box using the field 'existence'
simply taking
=if(isnull([Date]),'Does not exist', 'exists')
seems to work for me. What output do you get? just a blank list box? please also check that the field name is correct and the field is populated

Re: IF NULL THEN... syntax

anonymous1 — Tue, 09 Jul 2019 07:48:41 GMT

hi,

thanks to everyone for the responses, this seems to have worked. however, the 'Does Not Exists' option (i.e. all the NULLs) remains grey and never lets me select this. any idea why that would be?

Re: IF NULL THEN... syntaxhi,

anonymous1 — Tue, 09 Jul 2019 08:26:06 GMT

hi,

the 'Does not exists' option now remains permanently grey, and wont let me select it. any ideas why that would be?

Re: IF NULL THEN... syntaxhi,

trdandamudi — Tue, 09 Jul 2019 11:25:23 GMT

That is because your date is null/space and you cannot filter on null/space in qlikview.