Discussion board where members can get started with Qlik Sense.
Approval Table Loaded Table
Access Table Load table
Access Validation (In App Join Table)
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.
Go to Solution.
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....
LOAD [Computer Name],
If(Len(Trim([Access level])) > 0, [Access level], 'No Approval') as [Access level]
DROP Table Approval_Temp;
if(Len(Trim(([Access Level])))=0, 'No approval', [Access Level]