topic Re: Function "COUNTIFS" in App Development

Function "COUNTIFS"

Anonymous — Mon, 28 May 2018 04:17:57 GMT

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 — Tue, 29 May 2018 14:40:35 GMT

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 — Tue, 29 May 2018 15:52:50 GMT

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 — Tue, 29 May 2018 16:35:40 GMT

This

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

Anonymous — Wed, 30 May 2018 01:45:41 GMT

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

Regards,

Banu