Function "COUNTIFS"

[Anonymous]

Dear All,

I would like to count amount of employee (empl), contractor (cont)  and guest (gues) that accessing certain gate (let say GATE-01 and GATE-02).

In Excel I use  "COUNTIFS" function, and it's work well.

Unfortunately, I didn't find "countifs" function at Qlik sense.

Please advise how to do it at Clik sense? I will use    KPI to show it.

Thank you.

Regards,

Banu

[sunny_talwar]

You can do this for KPI

Count GATE-01

Count({<GATE = {'GATE-01'}>} GATE)

Count GATE-02

Count({<GATE = {'GATE-02'}>} GATE)

For the pivot chart, you can create a pivot table with two dimension

GATE

STATUS

Expression

Count(GATE)

[Anonymous]

Thank Sunny, it's works for KPI with single condition.

How do I do If would like to have KPI with two condition. Let say "How many EMPL accessing GATE-01?"

What function equal with "countifs" on Excel?

Thanks.

Regards,

Banu

[sunny_talwar · Accepted solution]

This

Count({<GATE = {'GATE-01'}, STATUS = {'empl'}>} GATE)

[Anonymous]

Thank you very much Sunny...., it's work.

Regards,

Banu