Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
menphis12
Contributor
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
Ivan_Bozov
Luminary
Luminary

In your script define the field as follows:

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

vizmind.eu
menphis12
Contributor
Contributor
Author

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

Ivan_Bozov
Luminary
Luminary

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.

vizmind.eu