topic Re: Calculated field in pivote table in QlikView

Calculated field in pivote table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Calculated field in pivote table

sunny_talwar — Mon, 12 Mar 2018 11:36:53 GMT

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

Re: Calculated field in pivote table

Anonymous — Mon, 12 Mar 2018 11:50:47 GMT

Sorry Sunny i can't share.

Re: Calculated field in pivote table

sunny_talwar — Mon, 12 Mar 2018 11:52:40 GMT

no problem

Re: Calculated field in pivote table

Anonymous — Mon, 12 Mar 2018 12:01:23 GMT

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

Re: Calculated field in pivote table

shiveshsingh — Mon, 12 Mar 2018 12:02:41 GMT

Please share sample to brainstorm

Re: Calculated field in pivote table

sunny_talwar — Mon, 12 Mar 2018 12:03:21 GMT

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

Re: Calculated field in pivote table

Nagaraju_KCS — Mon, 12 Mar 2018 13:03:28 GMT

PFA,

Re: Calculated field in pivote table

Anonymous — Tue, 13 Mar 2018 05:10:16 GMT

Hi Raju,

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

Re: Calculated field in pivote table

Nagaraju_KCS — Tue, 13 Mar 2018 05:20:42 GMT

In expression tab, change Expression total to Sum..