topic How to search missing value on the app Qilksense? in App Development

How to search missing value on the app Qilksense?

menphis12 — Mon, 08 Oct 2018 13:05:49 GMT

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

Re: How to search missing value on the app Qilksense?

Ivan_Bozov — Mon, 08 Oct 2018 18:34:02 GMT

In your script define the field as follows:

IF(LEN(TRIM(Amount_Paid))=0, 'Missing_Amount', Amount_Paid) AS Amount_Paid

Re: How to search missing value on the app Qilksense?

menphis12 — Tue, 09 Oct 2018 08:31:43 GMT

Hello

THanks for the answer

I am talking about inside the sheet directly, not in the script.

See the picture attached

Re: How to search missing value on the app Qilksense?

Ivan_Bozov — Wed, 10 Oct 2018 06:44:51 GMT

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.