Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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
This
Count({<GATE = {'GATE-01'}, STATUS = {'empl'}>} GATE)
Thank you very much Sunny...., it's work.
Regards,
Banu