topic Re: Help with setting proper Dimensions on my Pivot Table in QlikView

Help with setting proper Dimensions on my Pivot Table

Wed, 15 Jun 2011 13:30:15 GMT

Hi everyone, i hope u can help me!

I have a pivot table with 2 dimensions, example: 1-Letters, 2-Numbers. And i have also some expression but i think the problem is not there.

What i have is

Letter Numbers Expr1

A 13 100

14 100

16 100

----------------

B 21 50

31 50

51 50

---------------

C 15 50

61 50

91 50

---------------

The problem is i need to group item B and C as it was a unique item in the first dimension and then i need to explode it, they want to see item B and C as it was a single item but they also want to be able to explode then and see them as different items. (First Question)

Ex:

Letter Numbers Expr1

A 13 100

14 100

16 100

----------------

BC ( + ) 21 50

31 50

51 50

15 50

61 50

91 50

I need also to be able to see it like this:

Letter Numbers Expr1

A 13 100

14 100

16 100

----------------

BC ( + ) B 21 50

31 50

51 50

C 15 50

61 50

91 50

It is possible to create a view like this using pivot table? Hope you can help me...

Help with setting proper Dimensions on my Pivot Table

brenner_martina — Wed, 15 Jun 2011 14:21:03 GMT

Hi, Lucas,

yes it is possible, create a new dynmaic dimension like this:

=If(letter='A','A','BC')

Re: Help with setting proper Dimensions on my Pivot Table

Wed, 15 Jun 2011 14:47:35 GMT

Hi,

Thanks for helping me.

This solve question one, right now i have the 'BC' item created, but after that i need also to be able to break the BC item so i can see B and C separated

And now? xD

Well, could be something like this

I have now the items

is it possible when i click in BC item it break then into B and C like

and if i click again i will group then into BC this would solve this topic

Help with setting proper Dimensions on my Pivot Table

brenner_martina — Wed, 15 Jun 2011 14:50:37 GMT

Hi, Lucas,

you can add the new dynamic dimension to you existing dimension letter!