Syntax using 2 Ifs.

[#1]

Dear Qlikview community,

As mentioned in my previous post, i'm new in qlikview and I need your help to achieve below calculation

Here is the formula using excel

=COUNTIFS(B13:B20,"A",C13:C20,"")

Count nationality if it's A and the final process is null

Here is the sample data

Nationality	Final Process
a
a
A
b
3

I appreciate your help

[HirisH_V7]

Hi,

Post your sample data and required output!

-Hirish

[sunny_talwar]

May be this:

Count({<Nationality = {'a', 'A'}, [Final Process] = {"=Len(Trim([Final Process])) = 0"}>} Nationality)

[#4]

Thanks Sunny,

It says error in expression.

Final Process is null and not 0.

Count nationality if it's A and the final process is null

Based on my above example, the answer is 3

Is there any other solution

[#5]

Hi Hirish,

Below is my sample data:

Nationality	Final Process
a
a
A
b
3

=COUNTIFS(B13:B20,"A",C13:C20,"")

Count nationality if it's A and the final process is null (and not 0)

The answer is 3

[#6]

Hi,

I keep getting error in expression.  Reference to above:

Count(if([Nationality]='A,a' AND IsNull([Final Process]) Nationality))

[sunny_talwar]

Can you share a sample to show where exactly it isn't working?

[ramasaisaksoft]

Hi CJ,

y don't you try like below?

script : Upper(UserName) as UserName

then select the nationality as A or a both are same

and in text box expression is like =count(UserName)

[Peter_Cammaert · Accepted solution]

What about:

Count(if(Upper([Nationality])='A' AND IsNull([Final Process]), Nationality))

[Kushal_Chawda]

=count( if(lower(Nationality)='a' and len(trim([Final Process]))<=0,Nationality,null()))