topic Re: calculating total values alone in pivot table in QlikView

calculating total values alone in pivot table

Mon, 23 Mar 2015 12:56:53 GMT

Hi experts,

i have the following straight table with some dimensions as BDM, 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 table(pivot or straight 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. but, if i hide branch column in straight table, i get the expected values.

Either of the two is fine i.e., pivot or straight, i have to make a table of total values of Lead BDM alone.

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 the same expressions (total alone).

how can i make it.

Please help me in this regard

Re: calculating total values alone in pivot table

Mon, 23 Mar 2015 14:16:06 GMT

try Sum(total <BDM> Field_Name)

Re: calculating total values alone in pivot table

Mon, 23 Mar 2015 15:12:55 GMT

hi,

thanks for ur reply.

I tried but its not working.

please provide me with complete script

Re: calculating total values alone in pivot table

Mon, 23 Mar 2015 16:01:26 GMT

You got to use that as an expression.

Re: calculating total values alone in pivot table

awhitfield — Mon, 23 Mar 2015 16:11:35 GMT

Hi PR,

are you able to add your qvw to the post please?

Andy

Re: calculating total values alone in pivot table

Mon, 23 Mar 2015 16:13:33 GMT

i tried in expression only. its showing zero values.

any other suggestions please

Re: calculating total values alone in pivot table

Mon, 23 Mar 2015 16:19:45 GMT

please see example built on test script.

Re: calculating total values alone in pivot table

Mon, 23 Mar 2015 16:27:30 GMT

i hav attached the sample qvw

please help me to calculate only the total of Lead BDM in another pivot table excluding BDM & branch

Re: calculating total values alone in pivot table

Mon, 23 Mar 2015 16:32:11 GMT

the total of Lead BDM for all expressions will be similar to the above screenshot

Re: calculating total values alone in pivot table

Mon, 23 Mar 2015 16:33:44 GMT

Based on your QVW

Re: calculating total values alone in pivot table

awhitfield — Mon, 23 Mar 2015 16:42:00 GMT

See the Attached

Re: calculating total values alone in pivot table

Tue, 24 Mar 2015 15:56:28 GMT

i hav attached the sample qvw

please help me to calculate only the total of Lead BDM in another pivot table excluding BDM & branch for all expressions