topic Re: Re: Subtotal of selections in QlikView

Subtotal of selections

Tue, 01 Oct 2013 18:54:42 GMT

Hello Guys, I need advice from you!

Below model of my problem.

A simple table would show the subtotal of selections as clusters ...

example:

A = ...(If I do not make any selections in A1: A3, the result is 30, if you select A1 and A2 (eg.) The result is 20)

A1 = 10

A2 = 10

A3 = 10

B = ...(If I do not make any selections in B1: B3, the result is 30, if you select B3 (p. ex.) The result is 10)

B1 = 10

B2 = 10

B3 = 10

A = 30

A1 = 10

A2 = 10

A3 = 10

B = 30

B1 = 10

B2 = 10

B3 = 10

A = 20

A1 = 10

A2 = 10

B = 10

B3 = 10

Any help will be appreciated!

Stive!

Re: Subtotal of selections

spividori — Tue, 01 Oct 2013 19:06:25 GMT

Hi.

If I understood correctly the problem, I attached a file of how I would solve it.

Regards.

Re: Subtotal of selections

Tue, 01 Oct 2013 19:13:57 GMT

Sandro Thanks for listening!

I need to show all the information on the same chart!

A = 20

A1 = 10

A2 = 10

B = 10

B1 = 10

What do you think?

Stive

Re: Re: Subtotal of selections

spividori — Tue, 01 Oct 2013 19:30:24 GMT

And if you change a pivot table, add Fld2 as second dimension and place it: "Show partial sum" for this?

Regards.

Re: Re: Subtotal of selections

Tue, 01 Oct 2013 19:33:07 GMT

It would be nice, but it is not as my client ...

Thank you!

Re: Re: Subtotal of selections

spividori — Tue, 01 Oct 2013 19:46:36 GMT

You could upload a picture or attach a file of how the result would.

To understand better.

Regards.

Re: Re: Re: Subtotal of selections

Tue, 01 Oct 2013 20:18:04 GMT

attached

Re: Subtotal of selections

Wed, 02 Oct 2013 17:23:10 GMT

Through Aggr managed to solve the problem.

Attached is the solution I found. It's just that I'm applying a model in another context.

The summary is this:

Records that has a number are children of another upper register.

Example: "A1" son of "A" and so on

1) When I do not select anything, the father should indicate the sum of the children.

2) When I select one or more records sons and his father, the father should indicate the sum of the children.

3) When I select one or more children, show them the value normally.

4) When I select only the father, he should indicate the sum of the children.

Stive

Re: Subtotal of selections

spividori — Wed, 02 Oct 2013 19:00:47 GMT

Hi.

Well, I could not understand what you need, but you has solved it, congratulations!.

Regards.