topic Re: Table Chart Calculated Total in Additional Field in QlikView

Table Chart Calculated Total in Additional Field

tiklabaq — Mon, 11 Dec 2017 12:02:24 GMT

Hi Guys,

I want to show in a table chart following total field:

Data:

Person	Working Hours	Costs	Month
P1	35	1000	03.2017
P1	36	1300	04.2017
P1	31	900	05.2017
P2	45	1000	03.2017
P2	54	2000	04.2017

Person	sum(Costs)	sum(Costs)	sum(Costs)
Month	03.2017	04.2017	05.2017
Total (Working Hours)	80	90	31
Total (Costs)	2000	3300	900
P1	1000	1300	900
P2	2000	2000	-

I know how I can show Total sum of Costs, but how can I show Total sum of Working Hours without a column in Expressions?

Re: Table Chart Total Additional Field

Anil_Babu_Samineni — Mon, 11 Dec 2017 12:11:14 GMT

May be this?

Re: Table Chart Calculated Total in Additional Field

tiklabaq — Mon, 11 Dec 2017 12:18:58 GMT

Hi Anil,

this is good. But what exactly do you make with Dim and why Dim is from 1-3?

Re: Table Chart Calculated Total in Additional Field

Anil_Babu_Samineni — Mon, 11 Dec 2017 12:49:28 GMT

To customize the special adding(not existing the rows) for special rows, I am creating sequential numbers using Dim which has 1,2,3 because In UI it showing Person, Costs, Hours. That means i am allocating to each Dim value to Person and Costs and Hours. After that i made expression to fit each dim of all measures for customize one..

Does it make sense ??

Note - Please mark it as helpful and Correct answer when applicable.

Re: Table Chart Calculated Total in Additional Field

tiklabaq — Mon, 11 Dec 2017 13:10:35 GMT

Hi Anil,

yes I understand. it's perfect. Many Thanks