calculated expression in pivot table

Mon, 25 Feb 2013 09:26:19 GMT

I have a pivot like this, the column of score is expression

the VbenchBR kinds of things are the variable with a default vaule i have set , my question is how to calculate the sum of total of by the table, it does not work when i have set the partial sum of it

if(RegionFullName='Brazil', [%Regular Students]/VbenchBR, if(RegionFullName='China',[%Regular Students]/VbenchCS,if(RegionFullName='France',[%Regular Students]/VbenchFR,if(RegionFullName='Germany',[%Regular Students]/VbenchGE,if(RegionFullName='Hong Kong',[%Regular Students]/VbenchHK,if(RegionFullName='Italy',[%Regular Students]/VbenchIT,if(RegionFullName='Japan',[%Regular Students]/VbenchJP,if(RegionFullName='Korea',[%Regular Students]/VbenchKR,if(RegionFullName='MEAST',[%Regular Students]/VbenchME,if(RegionFullName='Mexico',[%Regular Students]/VbenchMX,if(RegionFullName='ROA',[%Regular Students]/VbenchROA,if(RegionFullName='ROE',[%Regular Students]/VbenchROLA,if(RegionFullName='ROLA',[%Regular Students]/VbenchROLA,if(RegionFullName='ROW',[%Regular Students]/VbenchROW,if(RegionFullName='Russia',[%Regular Students]/VbenchRU,if(RegionFullName='Spain',[%Regular Students]/VbenchSP,if(RegionFullName='Taiwan',[%Regular Students]/VbenchTW,if(RegionFullName='Thailand',[%Regular Students]/VbenchTH,if(RegionFullName='US',[%Regular Students]

/VbenchUS)))))))))))))))))))

Code	Name	Region	Score
B	Adam	Brazil	0.7
		China	0
		France	1.1
		Germany	1
		Hong Kong	1.2
		Italy	0.3
		Japan	1.2
		Korea	0
		MEAST	0.1
		Mexico	0
		ROA	0
		ROE	1.3
		ROLA	0
		ROW	0
		Russia	0.2
		Spain	0
		Taiwan	0.4
		Thailand	0
		US	1.3
		Total	-

the total is not there

Re: calculated expression in pivot table

sujeetsingh — Mon, 25 Feb 2013 09:35:08 GMT

If possible use staright tabel

Re: calculated expression in pivot table

Mon, 25 Feb 2013 09:46:07 GMT

try this

sum(total score)

and properties-->presentation-->select dimension-->check on partial sum

then total show

topic Re: calculated expression in pivot table in QlikView

calculated expression in pivot table

Re: calculated expression in pivot table

Re: calculated expression in pivot table