Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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!

Community Browser