KPI Help

[#1]

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

[Anil_Babu_Samineni]

May be this?

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

[dinuwanbr]

Hi Hamid,

Can you upload a sample for better understanding?

Rgds,

Tharindu

[#4]

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

[#5]

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%.

[Anil_Babu_Samineni]

May be explain data set and result set needed.

[Kushal_Chawda]

Please specify the logic to calculate % and expected output