Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP
MVP

What about

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

View solution in original post

9 Replies
Highlighted
Master III
Master III

Try using the NullCount() function

Highlighted
MVP
MVP

Or maybe something like

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

Highlighted
Not applicable

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

Highlighted
Not applicable

I did this and it returned a count of 1-

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

Highlighted
MVP
MVP

What about

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

View solution in original post

Highlighted
Not applicable

Thank you so much!

Highlighted
Not applicable

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

Highlighted
MVP
MVP

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

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

Highlighted
Not applicable

Worked again. Thank you so much Stefan!