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: 
deepakkrish
Creator
Creator

Calculate non null, null, and completeness in the table

Hi Team ,

Please help me to complete this task .. I got one new requirement , I have a filter called ID. When I select ID it will show the values in another table .

My table:

nameaddressphone
a 87
b 88

 

Here we have 6 results and 2 null values , so I have to calculate overall results ,and null values and completeness based on the table ,, so my result would be

count : Overall values

null count: null value count

completeness : null values/overall count

nameaddressphonecountnullcompleteness
a 8731 
b 8831 
   overall 6null 20.67

 

Thanks,

Deepak

Labels (3)
1 Solution

Accepted Solutions
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

There you go:

clipboard_image_0.png

I think you have mistakes in your completeness logic.

null=2

full=6

completeness = null/full = 0.333

But your result showing 0.67, so I did both.

Do check which logic suits you better.

Refer qvw attached as reference.

 

Thanks and regards,

Arthur Fong

 

View solution in original post

4 Replies
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Do you have a sample app?

deepakkrish
Creator
Creator
Author

I don't have a sample to share for this .. My requirement is If you have a table that how may overall values and how many nulls and completeness for the table ..

Thanks,

Deepak.

Arthur_Fong
Partner - Specialist III
Partner - Specialist III

There you go:

clipboard_image_0.png

I think you have mistakes in your completeness logic.

null=2

full=6

completeness = null/full = 0.333

But your result showing 0.67, so I did both.

Do check which logic suits you better.

Refer qvw attached as reference.

 

Thanks and regards,

Arthur Fong

 

deepakkrish
Creator
Creator
Author

Thanks jkfong93 ..yes , Its working ..