topic Re: Subtotaling in QlikView

Subtotaling

thomas_skariah — Fri, 08 Jun 2012 06:03:28 GMT

Hi All,

Can anyone give an idea of how to calculate totals of two different rows into one.

For better understanding please view the attached image.

Regards

Tom

Subtotaling

Sokkorn — Fri, 08 Jun 2012 06:19:38 GMT

Hi Tom,

<Show Partial Sums> may do this. Let do it by Right Click on Pivot Table ==> Properties ==> Presentations ==> Check on Show Partial Sums

Apologize if I misunderstood your question.

Regards,

Sokkorn

Re: Subtotaling

thomas_skariah — Fri, 08 Jun 2012 06:30:01 GMT

Hi Sokkorn,

Thanks for your reply, but with partial sums it given totals of individual rows and in my scenario i need totals of A and B.

Please see the question mark given in the image.

Regards

Tom

Re: Subtotaling

Sokkorn — Fri, 08 Jun 2012 06:32:01 GMT

Hi Tom,

Can you share your app? We look into it together.

Regards,

Sokkorn

Re: Subtotaling

thomas_skariah — Fri, 08 Jun 2012 06:50:18 GMT

Hi Sokkorn,

Please find the attached sample Application.

Regards

Tom

Re: Subtotaling

Sokkorn — Fri, 08 Jun 2012 06:51:41 GMT

Get back you soon after meeting

Re: Subtotaling

thomas_skariah — Fri, 08 Jun 2012 10:05:39 GMT

Any one ,any Idea?

Regards

Tom

Re: Subtotaling

jonathandienst — Fri, 08 Jun 2012 10:24:56 GMT

Tom

This is usually done by adding a grouping field that groups A and B together, and then including that field as the first dimension.

You could create the field in script, or use a calc dimension, which could look like this (assuming A, B, ... are a field called Field1):

=Pick(Match(Field1, 'A','B','C','D'), 'A+B', 'A+B', 'C', 'D')

After you add in this calc dimension (let's name it Grouping' for the sake of example), enable the partial sum for Field1. This will create subtotals for 'Grouping' similar to your illustration.

Hope that helps

Jonathan

Re: Subtotaling

Sokkorn — Fri, 08 Jun 2012 10:58:48 GMT

Hi Tom,

See the sample attached file.

Regards,

Sokkorn

Re: Subtotaling

thomas_skariah — Fri, 08 Jun 2012 16:08:04 GMT

HI,

Thanks a lot Jonathan and Sokkorn for your kind support.

Regards

Tom