Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
srinivasa1
Creator II
Creator II

Hide repeated cols(Year) while exporting to excel

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.

5 Replies
srinivasa1
Creator II
Creator II
Author

Any help...

amars
Specialist
Specialist

Hi Sri Ram,

If I understood correctly you wish to have all the cells with same year to be merged in excel while exporting.

For this you can see the difference between the outputs when you click Send to Excel Icon and the Export when you right Click Copy To Clipboard -> Full Table -> Paste. The Second method gives you export the way you wish to Export the data.

To achieve this please check for examples with Obj.PasteSpecial that will give you the desired output.

Thanks

amars
Specialist
Specialist

Check this file.

srinivasa1
Creator II
Creator II
Author

Hi Thanks for suggestion .im getting error when im cliking on button. send to excel.it just opens script

srinivasa1
Creator II
Creator II
Author

Can you have any idea how we can do it in Qlikview, add on CIA report Manager?