4 Replies Latest reply: Mar 8, 2011 10:34 AM by Gareth Joubert RSS

    Cyclic groups in pivot tables


      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 1Week 2Week 3Week 4Week 5
      Category 1Product 1DATA
      Product 2
      Product 3
      Category 2Product 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

        • Cyclic groups in pivot tables
          Peter Rieper

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


          • Cyclic groups in pivot tables

            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.