Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
qlik_sara
New Contributor

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
Partner
Partner

Re: show table total in KPI

sum(all yourMeasure)

undergrinder
Valued Contributor II

Re: show table total in KPI

Hi Sara,

Try this:

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

The {1} identifier ignore selections.

G.

shiveshsingh
Honored Contributor

Re: show table total in KPI

May be this?

Sum(Total (NPV))