Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

menphis12
New Contributor

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

3 Replies
Luminary
Luminary

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

In your script define the field as follows:

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

Highlighted
menphis12
New Contributor

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

Hello

THanks for the answer

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

See the picture attached

capture barre de rechercher.PNG

Luminary
Luminary

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

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.