Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
for values where there is simply no value, the default is '-' and that cannot be filtered on.
Is there a way to make it default across the whole of Qlik so the value for anything without a value to be 'N/A'
Hello, I think this function could meet your expectations.
use this
IF(TRIM(LEN(FieldName))=0, 'N/A', FieldName)
Hi
Try like below