Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cwitman1
New Contributor III

if null not working

Approval Table Loaded Table

Computer NameEmployeeIDAccess Level
A1001234Admin
B1003456Admin
C1003667

Admin

Access Table Load table

Computer NameEmployeeID
A1001234
B1003456
C1003667
D1001567

Access Validation (In App Join Table)

Computer NameEmployeeIDAccess Level
A1001234Admin
B1003456Admin
C1003667

Admin

D1001567

The problem is I want the null access level fields to say 'no approval' so i can filter by this.

I have tried if(isnull([Access Level]), 'No approval', [Access Level].  This does not work.

Tags (3)
1 Solution

Accepted Solutions
MVP
MVP

Re: if null not working

Are you doing this after the join has taken place (in a resident load)? If not, then that's where you need to do this....

Approval_Temp:

LOAD [Computer Name],

     EmployeeID,

     [Access level]

FROM ....;

Join (Approval_Temp)

LOAD [Computer Name],

     EmployeeID

FROM .....;

Approval:

LOAD [Computer Name],

     EmployeeID

     If(Len(Trim([Access level])) > 0, [Access level], 'No Approval') as [Access level]

Resident Approval_Temp;


DROP Table Approval_Temp;

2 Replies
MVP
MVP

Re: if null not working

Are you doing this after the join has taken place (in a resident load)? If not, then that's where you need to do this....

Approval_Temp:

LOAD [Computer Name],

     EmployeeID,

     [Access level]

FROM ....;

Join (Approval_Temp)

LOAD [Computer Name],

     EmployeeID

FROM .....;

Approval:

LOAD [Computer Name],

     EmployeeID

     If(Len(Trim([Access level])) > 0, [Access level], 'No Approval') as [Access level]

Resident Approval_Temp;


DROP Table Approval_Temp;

stigchel
Honored Contributor

Re: if null not working

Try with

if(Len(Trim(([Access Level])))=0, 'No approval', [Access Level]