show table total in KPI

[Anonymous]

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.

	Company	Project	Year	NPV
	X	1	2018	3
	X	2	2019	3
	Y	3	2020	3
	Z	4	2018	5
	Z	5	2019	5
	Z	6	2020	5
	TOTAL			24

[OmarBenSalem]

sum(all yourMeasure)

[undergrinder]

Hi Sara,

Try this:

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

The {1} identifier ignore selections.

G.

[shiveshsingh]

May be this?

Sum(Total (NPV))