CountIfs

[alwayslearning]

Hi,

I am new to Qlik and so help would be much appreciated. I am trying to perform what in Excel would be CountIFS.  Counting based on multiple Columns.

I want to be able to count nulls for Multiple Columns: e.g.

Group	Forename	Surname	Age
1	John	Smith	51
1	Sam	Shaw	21
2	Harold
2	Amy
3		Jones

You can see in Forename there is 1 Null, Surname has 2 and Age has 3.  I want to be able to count these nulls in various ways.

1. I want to be able to sum the null of multiple columns i.e. Forename + Surname = 3 Nulls

2. I want to be able to sum the null of multiple columns and then base it on multiple groups i.e. Forename + Surname of Group2 = 2 Nulls & Forename + Surname of Group2 +3 = 3 Nulls etc.

I've come across countif through: =count({<Field={'A','B'}>} Field), which I think is a good starting point.

Thank you.

Qlikview Novice

[MarcoWedel]

you're welcome.

Glad it worked.

Please close your thread if your question is answered:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco

[Digvijay_Singh]

Good to hear that marcowedel 's solution worked for you

In your expression you have used [Project Id] at once place, in different case than [Project ID], that may cause problem.

You can close this thread by marking one correct answer and  as many helpful, likes as you feel.

take care,

DJ