topic Re: pivot table calculations in QlikView

pivot table calculations

Wed, 25 Mar 2015 10:06:28 GMT

hi experts

i hav attached the sample qvw

i have a straight table with some dimensions as Branch, Lead BDM and some expressions(which is calculated using conditional formulas). all the expressions do not have sum() calculation. so i have made a total of the rows and that total is displayed on top.

Now, i need to make another pivot table which should display only the total of the dimensions named Lead BDM.

the problem is the calculation of expressions depends on the particular branch. so if i hide the branch column in pivot table, some values are showing null

for ex.

i have lead BDM names as

Andy,

Antony,

Nick,

Peter,

Chris,

David, etc....

Now i have to make a table showing the totals alone.

i.e., Total: Lead BDM Andy,

Total: Lead BDM Antony,

Total: Lead BDM Nick, etc... with all the same expressions (total alone).

how can i make it.

Please help me in this regard

Re: pivot table calculations

mrossoit — Wed, 25 Mar 2015 10:15:03 GMT

Your file seems to be broken.

Post it again

Re: pivot table calculations

stigchel — Wed, 25 Mar 2015 10:30:19 GMT

Remove the dimension and then you can use the Aggr function in combination with sum like this:

=Sum(Aggr(YourExpression),[Branch Name]))

Re: pivot table calculations

stigchel — Wed, 25 Mar 2015 10:43:39 GMT

More background on the Aggr function for example here:

QlikView Technical Brief - AGGR.docx

Re: pivot table calculations

Wed, 25 Mar 2015 11:01:11 GMT

try this expression

=Sum(Aggr(Your Expression),[Branch Name]))

Re: pivot table calculations

Wed, 25 Mar 2015 11:42:03 GMT

hi Piet Hein,

its working

thanks a lot