topic pivot table not showing total in QlikView

pivot table not showing total

harleen_singh — Tue, 03 Apr 2012 12:14:19 GMT

Hello i have a data like this

ID	Amount in Euro	rate
1	1600	3
2	2500	4
3	2300	5

i am using this formulat to caculate

=sum(AMOUNTCUR)/Rate

it is showing the correct sum with the rate divided by this But its not showing the Total when i select partial sum??

what may be the problem??

thanks

Lavi

pivot table not showing total

Anonymous — Tue, 03 Apr 2012 12:24:30 GMT

hi did u try

=sum(AMOUNTCUR / Rate )

pivot table not showing total

sivarajs — Tue, 03 Apr 2012 12:26:00 GMT

Its giving actually, may be check in number format

Sivaraj S

pivot table not showing total

harleen_singh — Tue, 03 Apr 2012 13:31:41 GMT

Sivaraj,

i have checked it with number format but its the same.

alfasierra

I have already tried it with sum(AMOUNTCUR / Rate ) but it shows correct values and sum too but

for one column its showing wrong value. the value is double the amount should i get.

i don't know why

pivot table not showing total

sivarajs — Tue, 03 Apr 2012 13:34:32 GMT

Can u attach sample

Re: pivot table not showing total

harleen_singh — Tue, 03 Apr 2012 13:50:42 GMT

Sivaraj,

can you see the sample file? and see the top value of column Depreciation Euro . All values are divided except that top value. It should be divided by 2 in this case

(Select year 2010 and AssetID FA00000010)

thanks

pivot table not showing total

Anonymous — Tue, 03 Apr 2012 14:18:12 GMT

try this

=if(TRANSTYPE=3 or TRANSTYPE=4,sum(AMOUNTCUR)/Rate)

pivot table not showing total

sivarajs — Wed, 04 Apr 2012 04:53:21 GMT

Hi Lavi,

You meant to say that for asset other than FA00000010 you are not getting Depreciation Euro

am i right??

Sivaraj S

Re: pivot table not showing total

harleen_singh — Wed, 04 Apr 2012 12:39:24 GMT

@sivaraj,

no for the asset FA00000010 i am getting all the values of Depreciation Euro correctly except the one value at the top. (only top one value of Depreciation Euro has problem

thanks

Lavi

Re: pivot table not showing total

sivarajs — Wed, 04 Apr 2012 13:51:28 GMT

Hi lavi,

Change your expression like

=sum(if(TRANSTYPE=3 or TRANSTYPE=4 ,(AMOUNTCUR)))/Rate

See the attached file