Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

app help - null fields

Hi,

We would like an app to populate an answer in a field if its blank and meets criteria. We have tried adding two expressions to the script but neither works:


"e_mail",if(e_mail = "-", 'No email', 'Has email'),

or

  "tency_end_dt", if(tency_end_dt = null, 'Current Tenancy', 'Previous Tenancy'),

Any suggestions/advice?

Much appreciated.

Chris

10 Replies
marcus_sommer

Most often you didn't really want to check if a field(value) is NULL (the '-' within the table-charts is only a replace-char for NULL and could be changed within the tab presentations on the bottom left) else you want check if no (valid) value is available. With len(trim()) you caught not only NULL else empty strings (for example this: = '' is not NULL) and not printable chars like leading spaces or many types of special chars. Very good explanations could you find here:

NULL – The Invisible Nothing

Finding NULL

- Marcus