- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to search missing value on the app Qilksense?
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
In your script define the field as follows:
IF(LEN(TRIM(Amount_Paid))=0, 'Missing_Amount', Amount_Paid) AS Amount_Paid
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello
THanks for the answer
I am talking about inside the sheet directly, not in the script.
See the picture attached
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.