topic Re: KPI Help in QlikView

KPI Help

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Reasonably new to QlikView.

Require help to create a KPI (using text object) which considers a condition

Condition = Where fieldname = 'Critical'

A time difference is checked...2 fields ( Start time and End time)

Time difference is then checked against a fixed number from another field (Target)

If target is exceeded(fails) want to display a % of failures.

Thanks

Shahid

Re: KPI Help

Anil_Babu_Samineni — Thu, 21 Sep 2017 01:06:25 GMT

May be this?

Sum(Aggr(If(([Start time] - [End time]) > Target, Num(Sum({<fieldname = {'Critical'}>} Measure),'#,#0%')), [Start time], [End time]))

Re: KPI Help

dinuwanbr — Thu, 21 Sep 2017 03:40:34 GMT

Hi Hamid,

Can you upload a sample for better understanding?

Rgds,

Tharindu

Re: KPI Help

Fri, 22 Sep 2017 10:44:00 GMT

Just a add a little more context

Checking 'incident age' vs 'target' and calculating the number of Breached or Met strings for each priority as a %.

If target exceeds 80% then present % as a green text with words exceeds target and lower than 80% as lower than target. Hope this helps.

INCIDENT AGE (mins)	PRIORITY	STATUS	TARGET (mins)
200	CRITICAL	BREACHED	120
20	CRITICAL	MET	120
39	MEDIUM	MET	750
45	MEDIUM	MET	750
900	HIGH	BREACHED	500
12	HIGH	MET	500
67	LOW	MET	1000

Re: KPI Help

Fri, 22 Sep 2017 11:48:23 GMT

INCIDENT AGE (mins)	PRIORITY	STATUS	TARGET (mins)
200	CRITICAL	BREACHED	120
20	CRITICAL	MET	120
39	MEDIUM	MET	750
45	MEDIUM	MET	750
900	HIGH	BREACHED	500
12	HIGH	MET	500
67	LOW	MET	1000

To clarify.. another viewpoint... for each PRIORITY count STATUS type and display % for PRIORITY category. Guess can have KPI for each PRIORITY. If % value 80% then Green text for % vale with 'Exceeded Target' wording and vice versa below 80%.

Re: KPI Help

Anil_Babu_Samineni — Sun, 24 Sep 2017 05:38:15 GMT

May be explain data set and result set needed.

Re: KPI Help

Kushal_Chawda — Sun, 24 Sep 2017 09:34:06 GMT

Please specify the logic to calculate % and expected output