# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for
Did you mean:
Partner

## Total by Dimension for KPI

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

 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%
Labels (3)

• ### Total

1 Solution

Accepted Solutions
MVP

Try this

``````=Num(Sum(Aggr(

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

2 Replies
Creator

Hi,

Would this KPI object be of any help to you?

MVP

Try this

``````=Num(Sum(Aggr(

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