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

[jagan]

HI,

Try like this

Count({<Nationality={'A'}, [Final Date] -= {'*'}>} FieldName)

Note: The above expression shows as syntax error but it works.

Regards,

Jagan.

[#3]

Thanks Peter,

I think this is the correct syntax.

Regards,

Obet