Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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!

Tags (3)
1 Solution

Accepted Solutions
MVP
MVP

Re: Joining tables and counting new null values

What about

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

9 Replies
Digvijay_Singh
Honored Contributor III

Re: Joining tables and counting new null values

Try using the NullCount() function

MVP
MVP

Re: Joining tables and counting new null values

Or maybe something like

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

Not applicable

Re: Joining tables and counting new null values

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

Not applicable

Re: Joining tables and counting new null values

I did this and it returned a count of 1-

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

MVP
MVP

Re: Joining tables and counting new null values

What about

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

Not applicable

Re: Joining tables and counting new null values

Thank you so much!

Not applicable

Re: Joining tables and counting new null values

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

MVP
MVP

Re: Joining tables and counting new null values

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

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

Not applicable

Re: Joining tables and counting new null values

Worked again. Thank you so much Stefan!