Cyclic groups in pivot tables

[#1]

Hi

In the set up of a pivot table I have input for different expressions and have the time period runnning across the top of the table ("Week" or "Months").

When I tried to group the expressions in a cyclic group it will not allow me to cycle between them.

Example of pivot table below:

		Week 1	Week 2	Week 3	Week 4	Week 5
Category 1	Product 1	DATA
	Product 2
	Product 3
Category 2	Product 4
	Product 5
	Product 6
	Product 7

I am using Qlikview 9. Do you know what I am doing wrong or if there is any way around it?

Thanks, Gareth

[prieper]

Think that this behaviour is by default.
As workaround toggle to straight-table, change the group and go back to pivot.

HTH
Peter

[#3]

Thanks Peter. Unfortunately I was hoping to publish this report for all the end users to utilise. Is the only option to do four different reports or have them all in one location?

[#4 · Accepted solution]

You're not doing anything wrong. The cyclic button will not appear because there's nowhere for it to go. You've pivoted the table to display your week/month dimension along the horizontal which means the dimension label is not displayed - this is where the button goes by default.

Annoying as it is, you can achieve exactly what you require using a button/text object (see below).

Here, I'm using the green + button to set the variable vShowAbsoluteRelative. You need to create two PTs in exactly the same location, one with week and one with month as the dimensions and then use conditional show on the PT based on the variable vShowAbsoluteRelative. The value entry is as follows:

=if(vShowAbsoluteRelative = 'Absolute', 'Relative', 'Absolute')

So, when a user presses the button, the variable toggles between absolute/relative and one of the two PTs appears/dissapears. You can hide/show as many objects as you like using this method.

[#5]

Thanks APS