4 leves in a Pivot Table

Thu, 25 Feb 2010 18:51:38 GMT

w3esdxcv zxHi everyone, maybe you can help me:

I'm trying to create a pivot table with 4 dimensions and 4 expressions. The expressions are simply sums, but the problem I have is with the dimensions. What I want to do is a 4-level dimension but being able to change the order of the groups, so I load in the script the following code,

Load * Inline [
Level1, Level2, Level3, Level4
Fruit, Fruit, Fruit, Fruit
Variety, Variety, Variety, Variety,
Customer, Customer, Customer, Customer
Lot, Lot, Lot, Lot];

The first column should be the first dimension. The 4 dimensions are created this way:

Where Nivel1 means Level1. So the problem is that I want to have another table besides this pivot table with 4 columns. Every column will have the four values (Fruit, Variety, Customer, Lot) and when I choose one value from the first column (Level1) the pivot table will update using that value as the first dimension. And the same with the other three columns. I've tried to do it but when i choose a value in the first column the others filter to that value, so eventually all the dimensions in the pivot table take the same value.

Thanks in advance for your help.

topic 4 leves in a Pivot Table in QlikView

4 leves in a Pivot Table