topic Re: Re: Subtotals Pooled in QlikView

Subtotals Pooled

pgalvezt — Tue, 10 Jun 2014 20:46:24 GMT

Hi,

I have a Pivot table that show different states over codes.

Actually I have to expand the dimension to show the diferent states but by Code.

Is there a way to show all states by family. Actually QlikView shows any result (only one result, I dont know how Qlikview Obtain the family result)

Present:

Familia: Accesorios

Sin Cambios 7890.

Familia: Bombas

Sobrestock ---> Compras<1año 787.655

What I want: By Family shows all states (and no only one)

Familia: Accesorios

Sin Cambios 7890.

Compras<1año 787.655

Entre 0 y 1 año ----> Inm 567.332

I attached an example,

Thanks,

pgalvezt — Tue, 10 Jun 2014 21:22:43 GMT

I put an example excel example test of What I want to obtain.

Thanks!

pgalvezt — Wed, 11 Jun 2014 13:07:53 GMT

Any Help?

Thanks!

Wed, 11 Jun 2014 13:14:05 GMT

If you make many selections, QlikView will show multiple families in your pivot table. See the attached qvw.

pgalvezt — Wed, 11 Jun 2014 13:29:47 GMT

Hi Jacob,

I know that but is not what I want. What I want is to have a subtotals pooled but only by family.

Like excel file...

Thanks!

pgalvezt — Wed, 11 Jun 2014 17:14:41 GMT

Anybody can help me with this?

Thanks!

pgalvezt — Thu, 12 Jun 2014 20:13:55 GMT

Anyone?

Thanks!