Total by Dimension for KPI

win_anthony — Sat, 16 Nov 2024 00:23:11 GMT

My goal is to have the results of an expression (ex: Annualized Savings) be highlighted on a KPI. Problem is that I am not sure on how to write the expression for the KPI without the Dimension (ex: Charge Task Code). Below is an example. I have table with the Dimension (Charge Task Code) and the expression (Annualized Savings).

The table is providing the exact information I need and just want to have KPI to highlight the information. How can I write this expression to be reflected in a KPI? Example KPI > Annualized Savings = $10,392.87

Annualized Savings

= num((sum({<[Task / Expense (LEDES Type)] = {"*Expense*"},[Charge Task Code]-={"*NONE*","*UNKNWN*"}>} [Effective (Post-Adjustment) Total])/$(vCountYears))*[Best Practice % Reduction],'$#,##0.00')

Charge Task Code	Annualized Expenses	HBR Best Practice % Reduction	Annualized Savings	Savings % of Annualized Spend
	$134,959.67		$10,392.87
E101	$574.74	100%	$574.74	100%
E102	$15,842.40	30%	$4,752.72	30%
E103	$123.60	100%	$123.60	100%
E104	$14.40	100%	$14.40	100%
E105	$8.73	100%	$8.73	100%
E106	$1,225.39	100%	$1,225.39	100%
E107	$4,502.83	30%	$1,350.85	30%
E108	$28.48	100%	$28.48	100%
E109	$2,313.98	100%	$2,313.98	100%
E110	$110,325.14	0%	$0.00	0%

Re: Total by Dimension for KPI

basav — Thu, 02 Jul 2020 16:38:03 GMT

Hi,

Would this KPI object be of any help to you?

check this link: https://community.qlik.com/t5/Qlik-Design-Blog/Creating-a-KPI-object-in-QlikView/ba-p/1468447/page/5#comments

Re: Total by Dimension for KPI

sunny_talwar — Thu, 02 Jul 2020 16:44:07 GMT

Try this

=Num(Sum(Aggr( (Sum({<[Task / Expense (LEDES Type)] = {"*Expense*"}, [Charge Task Code] -= {"*NONE*","*UNKNWN*"}>} [Effective (Post-Adjustment) Total])/$(vCountYears))*[Best Practice % Reduction] , [Charge Task Code])), '$#,##0.00')

topic Re: Total by Dimension for KPI in QlikView

Total by Dimension for KPI

Re: Total by Dimension for KPI

Re: Total by Dimension for KPI