1 Reply Latest reply: Dec 30, 2011 9:46 AM by Ashutosh Paliwal RSS

    How to Save the Results of a Pivot Table as XML in qlikview

      How to Save the Results of a Pivot Table as XML in qlikview? The export of a pivot table produce a structure as well as a straight table...I need export xml with pivot structure...any ideas? thanks

        • How to Save the Results of a Pivot Table as XML in qlikview
          Ashutosh Paliwal

          Dear Maxi,

                           The problem is of the same names shared by more than 1 field in your pivot table because in XML you can not have same name for more than 1 field.

          So, you may have noticed that if you have only 1 expression and only 1 dimension horizontally then it will export fine but as soon as you add more than 1 expression or 1 more dimension horizontally then it will rename the next same value for field and make one more field which will contain the original name of the field.

          Then I believe you can not export it as a pivot when you create more than 1 column in your pivot with same value.

           

          Hope it helps.

           

           

          Regards,

          Ashutosh