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: 
Not applicable

Joining tables and counting new null values

Hi everyone,

I'm joining two tables together by [ITMSNumber]. There's 11,000 [ITMSNumber]. Associated with that [ITMSNumber] there is [Application Status]. There is only 10,000 associations between [Application Status] and [ITMSNumber]. The rest of the 1,000 [ITMSNumber] get Null values for their [Application Status]. How do I count those Null values?

Thanks oodles!

1 Solution

Accepted Solutions
swuehl
MVP
MVP

What about

Count( {<ITMSNumber = e({<[Application Status] = {"*"}>}) >} DISTINCT ITMSNumber)

View solution in original post

9 Replies
Digvijay_Singh

Try using the NullCount() function

swuehl
MVP
MVP

Or maybe something like

Count( {1-<[Application Status] = {"*"}>} DISTINCT ITMSNumber)

Not applicable
Author

It seemed right but it didn't work. It just counted everything

Not applicable
Author

I did this and it returned a count of 1-

=NullCount ( {1-<[Application Status]>}DISTINCT ITMSNumber)

swuehl
MVP
MVP

What about

Count( {<ITMSNumber = e({<[Application Status] = {"*"}>}) >} DISTINCT ITMSNumber)

Not applicable
Author

Thank you so much!

Not applicable
Author

Now how do I make an action that selects only those rows?

swuehl
MVP
MVP

Use ITMSNumber as field in your Select in field action and as search string

='=Sum({<ITMSNumber = e({<[Application Status] = {"*"}>}) >} 1)'

Not applicable
Author

Worked again. Thank you so much Stefan!