Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Calculated field in pivote table

Hello everyone,

My requirement is to show subtract total value at bottom of table(Horizontally).

I have 4  KPI . i want to subtract A from D ie D-A  which is know as Balance at the bottom of table.

KPI

2014

2015

2016

Q1 2017

Q2 2017

A

20

40

50

25

30

B

14

16

10

5

8

C

22

35

26

12

3

D

50

70

75

90

60

Balance

30

30

25

65

30

  i am not getting how it is possible. please help me to find out.

Thanks.

9 Replies
sunny_talwar

Would you be able to share a sample where you are trying this out?

Anonymous
Not applicable
Author

Sorry Sunny i can't share.

sunny_talwar

no problem

Anonymous
Not applicable
Author

it is possible to show specific field value calculation in pivot table?

shiveshsingh
Master
Master

Please share sample to brainstorm

sunny_talwar

I think it is possible... but since I don't know how everything is setup for you... don't really know how to help.... May be someone else can offer advice...

qv_testing
Specialist II
Specialist II

PFA,

Anonymous
Not applicable
Author

Hi Raju,

you used subtraction  for but still it shows addition in 2014 and remaining are empty.

 

qv_testing
Specialist II
Specialist II

In expression tab, change Expression total to Sum..

ABC.JPG