Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Jérôme5625
Creator
Creator

Filter on empty elements

Hello, I am a beginner on the Qlik software. I managed to make several graphs and several set analysis. however I am stuck on a function. I want my sheet to open taking into account that the data or my column (="date cloture") are empty. I did not succeed in writing the set analysis which takes into account the check of the empty elements.

Could you help me to know exactly the correct syntax?

Have a nice day

count({$<[Avis_ Date de clôture.autoCalendar.Date]="">} [Avis_ Auteur])

Labels (1)
1 Solution

Accepted Solutions
BrunPierre
Partner - Master
Partner - Master

Almost there, only missing the parenthesis.

Count({$<[Avis_ Date de clôture.autoCalendar.Date]={""}>} [Avis_ Auteur])

View solution in original post

1 Reply
BrunPierre
Partner - Master
Partner - Master

Almost there, only missing the parenthesis.

Count({$<[Avis_ Date de clôture.autoCalendar.Date]={""}>} [Avis_ Auteur])