topic Calculate non null, null, and completeness in the table in QlikView

Calculate non null, null, and completeness in the table

deepakkrish — Sat, 16 Nov 2024 19:55:36 GMT

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:

name	address	phone
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

name	address	phone	count	null	completeness
a		87	3	1
b		88	3	1
			overall 6	null 2	0.67

Thanks,

Deepak

Re: Calculate non null, null, and completeness in the table

Arthur_Fong — Thu, 10 Oct 2019 07:15:47 GMT

Do you have a sample app?

Re: Calculate non null, null, and completeness in the table

deepakkrish — Thu, 10 Oct 2019 07:21:48 GMT

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.

Re: Calculate non null, null, and completeness in the table

Arthur_Fong — Thu, 10 Oct 2019 08:35:42 GMT

There you go:

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

Re: Calculate non null, null, and completeness in the table

deepakkrish — Thu, 10 Oct 2019 09:07:27 GMT

Thanks jkfong93 ..yes , Its working ..