2 Replies Latest reply: Feb 1, 2017 11:08 AM by Michalina Kuczynska RSS

    Weird Behaviour with Pivot Table

    Andrew Whitfield

      Morning folks,

       

      weird one reported by one of a clients, check out the screen shot below:

       

       

       

      The expand icon on the HRG dimension shows that it's fully expanded, but no values display for the Consultant OR Episode ID. IF the chart is swapped to a Straight Table, the data appears!

       

       

      Any ideas? They are running on 11.00 SR2.

       

      Thanks in advance Andy

        • Re: Weird Behaviour with Pivot Table
          Marcus Sommer

          I remember that there was a similar case but not when and if there was a solution. At first I would try to display these values by right-clicking on the description field and fully expand the following columns instead of clicking on the single-icons. Another approach would be to recreate this table from the scratch in case that this table is corrupted in any way.

           

          ps: also an upgrade to a recent release might be helpful.

           

          - Marcus

          • Re: Weird Behaviour with Pivot Table
            Michalina Kuczynska

            Hi,

             

            Something very similar happened to me - we were using 2 different SR's of QV 11.20 and passing the qvw made tiny bits corrupted. Not sure if this is the case here, but probably the best idea would be to re-create the object.

             

            good luck!