Discussion board where members can learn more about Qlik Sense App Development and Usage.
I was wondering if it's possible to exclude null values in loadscript using Where Len(Trim([field])) > 0
Altough using field from another table.
Go to Solution.
You should be able to do it by either using ApplyMap in the condition for your table (where you pass a field to a mapping table) and evaluate the returned value using isnull or len, etc.
The second option is to perform an inner join on a table and only loading the joining column from the second table, but restricting it to where your field is not null.
Both these options will work. If you are still unsure then you can post a sample of your two tables I can help you with the script.