topic Pivot Table percentage error in QlikView

Pivot Table percentage error

Anonymous — Thu, 10 Dec 2015 06:16:19 GMT

I need help to fix the problem with pivot table percentage!

Regards,

Re: Pivot Table percentage error

Chanty4u — Thu, 10 Dec 2015 06:24:21 GMT

hi,

Re: Pivot Table percentage error

tresB — Thu, 10 Dec 2015 06:34:25 GMT

Your variable vUnitCost is evaluating to 0 (zero). Is that right?

Re: Pivot Table percentage error

avinashelite — Thu, 10 Dec 2015 06:38:11 GMT

could you please explain on which conditions we need to do the aggr ?

Re: Pivot Table percentage error

Anonymous — Thu, 10 Dec 2015 06:42:19 GMT

can I solve it without variable ?!

Re: Pivot Table percentage error

Anonymous — Thu, 10 Dec 2015 06:44:38 GMT

with [cost sheet grouping], [Account_No02] and [Item_Name002] . by the way I am not sure because I'm lost !

sorry

Re: Pivot Table percentage error

Anonymous — Thu, 10 Dec 2015 06:46:00 GMT

the total is not 100% !! can you check it again please..

Re: Pivot Table percentage error

tresB — Thu, 10 Dec 2015 06:47:41 GMT

To suggest that, I have to understand your model/data - which would be a time consuming process here. Unit cost in the column before, is totally different than your % calculation formula ! Aren't they related? What is your expected output?

Re: Pivot Table percentage error

Anonymous — Thu, 10 Dec 2015 06:49:05 GMT

Could you share the metrics, on what basis you are calculating Unit_Cost%???

Re: Pivot Table percentage error

Anonymous — Thu, 10 Dec 2015 08:03:00 GMT

(sum(Debit02-Credit02)/ sum(Quantity002)) this is the calculating for unit cost,, I need Unit Cost % for each [Account_No02] and the total of them 100%

Re: Pivot Table percentage error

Anonymous — Thu, 10 Dec 2015 08:08:54 GMT

like this?

Re: Pivot Table percentage error

Anonymous — Thu, 10 Dec 2015 08:31:15 GMT

no it's wrong the total is not 100%, I already make it right but it becomes null value until I select any category [Cost Sheet Grouping], Once I clear the selection the values become null !!

(sum(Debit02-Credit02)/Sum(Quantity002))/vUnitCost

vUnitCost = =sum({$}Debit02-Credit02)/Sum({$}Quantity002)

Re: Pivot Table percentage error

Anonymous — Thu, 10 Dec 2015 08:37:07 GMT

What is the logic of vUnitCost?

It is something like you are dividing 100 again by 100, how it can be?

Re: Pivot Table percentage error

Anonymous — Thu, 10 Dec 2015 08:39:52 GMT

if this is your requirement, then 2 alternates are:

1) Use Always Selected on Value Option

2) Set a trigger of selection in field on sheet activation