5 Replies Latest reply: Apr 23, 2013 8:50 AM by Srinivasa D RSS

    Hide repeated cols(Year) while exporting to excel

    Srinivasa D

      Hi,

       

      When exporting the pivot table  to excel Year repeating for Qurter.can any suggest how i can do the merge in qlikview as only one year .Im also using CIA report manger can anyone suggest how I can avoid in CIA Reports Manager

       

       

      EG

       

      Header 1Header 2Header 3Header 4Header 5Header 6Header 7Header 8

      2011
      2012Need to merge as one Year for 2012 ALSO
      Q1Q2Q3Q4Q1Q2Q3Q4

       

      Thanks in advance.