pivot table and cycle group

Anonymous — Tue, 31 Jul 2012 12:27:30 GMT

Hi folks,

I do have a pivot table with two dimensions and two expressions. The expressions are grouped by a cyclic group.

One dimension is shown in rows, while the other dimension is shown in column and the value of the expression in

correspondending cells.

BUT: in this scenario the "Cyclic Group" is not on display. I cannot switch between my expressions (as required).

Furthermore I donot see which expression is on display.

Dim 2

Dim 1 ValExpr1

-> If both dimensions are shown in rows, the cyclic display is on display. But I need it the first way!

Cycle Group

Dim 1 Dim2 ValExpr1

Workaround with my table without cycle group: switch to barchart, switch to desired expression and goback to

pivot table.

Any ideas how the cycle group can be shown in my scenario?

Regards

Re: pivot table and cycle group

jonathandienst — Tue, 31 Jul 2012 12:34:05 GMT

You might need to make two tables (one for each expression). You could then use autominimise, a container or conditional display to swicth between the two.

Not quite the same, just some workarounds.

Regards

Jonathan

topic Re: pivot table and cycle group in QlikView

pivot table and cycle group

Re: pivot table and cycle group