topic Re: If Condition in QlikView

If Condition

upaliwije — Sun, 31 Aug 2014 10:51:11 GMT

IF(ISNULL(TYPE)=0,'NOT_LEGAL',ELSE,'LEAGL')AS CATEGERY

I have written above code in my script. But It is not working. Can some correct it for me please.

My requirement is if TYPE is null then the category should be 'NOT LEGAL' else 'LEGAL'

Re: If Condition

northerner — Sun, 31 Aug 2014 11:09:11 GMT

Try:

if(isNull(TYPE), 'NOT LEGAL', 'LEGAL') as CATEGORY

IsNull will return 0 (representing false) is the TYPE field contains a non-null value. The Qlikview if statement syntax doesn't use the 'else' keyword - comma characters are used to separate the if/then/else parts of the statement.

Hope this helps!

Re: If Condition

Sun, 31 Aug 2014 11:09:58 GMT

Hi,

It should be like this:

IF(ISNULL(TYPE), 'NOT LEGAL', 'LEGAL') AS CATEGORY

Re: If Condition

upaliwije — Sun, 31 Aug 2014 11:15:31 GMT

Thanks for your reply and the explanation

Re: If Condition

Eduard23 — Thu, 10 Nov 2022 09:14:21 GMT

Hi What if i need multiple conditions like these?

This is my expression =IF(ISNULL(INVENTORY_STATUS=1), '', 'UNRESTRICTED') its working how can i add other expected result

Inventory Status	Expected Result
1	UNRESTRICTED
6EXP	BLOCKED
6DMG	BLOCKED
6QRN	QUARANTINE

Re: If Condition

BrunPierre — Fri, 11 Nov 2022 19:50:54 GMT

@Eduard23 as below

If(INVENTORY_STATUS=1,'UNRESTRICTED', If(INVENTORY_STATUS='6EXP','BLOCKED', If(INVENTORY_STATUS='6DMG','BLOCKED', If(INVENTORY_STATUS='6QRN','QUARANTINE',Null()))))

Re: If Condition

Eduard23 — Tue, 15 Nov 2022 10:54:07 GMT

i try this one it is working but then one from BrunPierre is also working, thanks

IF(INVENTORY_STATUS=1, 'UNRESTRICTED',IF(INVENTORY_STATUS='6DMG', 'BLOCKED',IF(INVENTORY_STATUS='6EXP', 'BLOCKED',IF(INVENTORY_STATUS='6QRN', 'QURANTINE', ''))))