Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
New on the community of Qliksense, i am trying to search missing value on a filed "Amount_Paid".
I have, some "Amout_Paid" not definied and i want to search on the app like "" or write missing value ?
How can we do it ?
Thanks
Avy
In your script define the field as follows:
IF(LEN(TRIM(Amount_Paid))=0, 'Missing_Amount', Amount_Paid) AS Amount_Paid
Hello
THanks for the answer
I am talking about inside the sheet directly, not in the script.
See the picture attached
Using what I suggested would give you an additional field value Missing_Amount that you can use in the search box.
Also please consider the data you have and make difference between NULLs and zero-length strings. A zero-length string would appear as an empty selectable field in you filter pane. NULL would not and you cannot search or select NULLs unless you do something on the back end.