Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Syntax using 2 Ifs.

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

                                        

NationalityFinal Process
a
a
A
b
3

I appreciate your help

31 Replies
jagan
Partner - Champion III
Partner - Champion III

HI,

Try like this

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

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

Regards,

Jagan.

Not applicable
Author

Thanks Peter,

I think this is the correct syntax.

Regards,

Obet