Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

show table total in KPI

Hi,

im trying to create a KPI object on qliksense that only shows the total. the NPV column is a calculated column which i created, but every time i select from the filter pane, it calculates the NPV for the numbers and doesnt show the total.

would really appreciate the support.

CompanyProjectYearNPV
X120183
X220193
Y320203
Z420185
Z520195
Z620205
TOTAL24
3 Replies
OmarBenSalem

sum(all yourMeasure)

undergrinder
Specialist II
Specialist II

Hi Sara,

Try this:

=sum({1} NPV) in KPI object.

The {1} identifier ignore selections.

G.

shiveshsingh
Master
Master

May be this?

Sum(Total (NPV))