Qlik Community

Ask a Question

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 
Search instead for 
Did you mean: 
win_anthony
Partner
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 

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

 

Charge Task CodeAnnualized ExpensesHBR Best Practice % ReductionAnnualized SavingsSavings % of Annualized Spend
 $134,959.67 $10,392.87 
E101$574.74100%$574.74100%
E102$15,842.4030%$4,752.7230%
E103$123.60100%$123.60100%
E104$14.40100%$14.40100%
E105$8.73100%$8.73100%
E106$1,225.39100%$1,225.39100%
E107$4,502.8330%$1,350.8530%
E108$28.48100%$28.48100%
E109$2,313.98100%$2,313.98100%
E110$110,325.140%$0.000%
Labels (3)
1 Solution

Accepted Solutions
sunny_talwar

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')

View solution in original post

2 Replies
basav
Creator
Creator

sunny_talwar

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')

View solution in original post