Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
eprehu
Contributor III
Contributor III

Recuperer ligne nulle

Bonjour,

J'aimerais recuperer les valeurs nulles, j'ai utilisé le isnull mais ca ne fonctionne pas : 

eprehu_0-1655367018766.png

Merci 

 

Labels (1)
3 Replies
maxgro
MVP
MVP

 

maybe the value is a blank, not a null, try with (replace value)

if(len(trim(value))=0 OR isnull(value), 'T', 'F')

 

 

eprehu
Contributor III
Contributor III
Author

Yes perfect thanks !!!!

eprehu
Contributor III
Contributor III
Author

But now, i want to count the number of customer who have no information about their age :

eprehu_0-1655369248512.png

But it doesn't work : 

eprehu_1-1655369285010.png