Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

wbwidodo
New Contributor II

Function "COUNTIFS"

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Function "COUNTIFS"

This

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

4 Replies
MVP
MVP

Re: Function "COUNTIFS"

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)

wbwidodo
New Contributor II

Re: Function "COUNTIFS"

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

MVP
MVP

Re: Function "COUNTIFS"

This

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

wbwidodo
New Contributor II

Re: Function "COUNTIFS"

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

Regards,

Banu

Community Browser