topic Re: Pivot table with 'steady' months in QlikView

Pivot table with 'steady' months

Anonymous — Mon, 29 Aug 2016 16:29:46 GMT

Hi, I have a pivot table with various dimensions that can be put on/off by the user via buttons. The pivot table has one measure.

One of the dimensions is WEEKYEAR. I want this dimension always to be the first one.

So I want

Week 35-2016 30-2016 24-2016 22-2016 ...

Dim1 Dim2 Dim3 Dim4 Dim5.. 10 20 10 30

However, when I let the user add dimensions, the sometimes appear above the week dimension, and that is not what I what. I already played arround with the order of the dimensions (promote-demote), but that doesn't solve it.

Any suggestions?

Het bericht is bewerkt door: Henk Leppers. I have added a simplified example. What I want is that no matter what dimensions are chosen via the buttons, the week dimension always has to stay on top (horizontal).

Re: Pivot table with 'steady' months

agomes1971 — Mon, 29 Aug 2016 17:18:31 GMT

Hi,

please post a sample it's easier to understand the logic you want to implement.

Thanks

André Gomes

Re: Pivot table with 'steady' months

MindaugasBacius — Tue, 30 Aug 2016 08:02:17 GMT

In what scenarios do you get the week below the other dimensions? What dimensions are on/off?

Re: Pivot table with 'steady' months

Anil_Babu_Samineni — Tue, 30 Aug 2016 08:06:12 GMT

Is this you are expecting?

Re: Pivot table with 'steady' months

Anonymous — Tue, 30 Aug 2016 08:10:38 GMT

Yes Mindaugas, that's what I want. But sometimes when I push one of the dimension button, the WEEK dimension dissappears.

Re: Pivot table with 'steady' months

Anonymous — Tue, 30 Aug 2016 08:11:44 GMT

For example: when I push the Code button, the WEEK dimension is gone...