This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board where members can learn more about Qlik Sense App Development and Usage.
I am trying to count how many empty values there in a single column. Here is a data sample :
I want to count all the null value in the Date column using set analysis which is supposed to be 5 null values. So far, I have tried these formula without success:
Can someone help me figure out a solution, please ?
Have you tried NullCount() function?
View solution in original post
If you are interested of counting nulls then you should look into the NullCount() function.
Try one of the below
Wow all three with the same advise within a couple of minutes @sunny_talwar @Anil_Babu_Samineni
Thank you Vegar, Anil and Sunny,
Following your suggestion, I tried to calculate the number of null values in all the table. So I want to do an addition with the nullcount Machine_ID, Date, Num_Incident.
But if I do the formula : NullCount(Machine_ID) + NullCount(Num_Incident), I get the value of 2 where I am supposed to find 0 null cells. Can you please explain why ?
May be they are not null and just while spaces? Difficult to know without playing around with it