Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
We need some better method to Export all the related charts/tables into a single Excel file.
We know that we have a macro for that but , we will face the issues if we use macros.
So please suggest some other alternative without macro.
or incase if this is not at all possible with macros , at least suggest how to do it with a single and small macro.
instead of writing macro to each and every chart/table its better if write it for including all.
Thanks in advance.
Best Regards,
Sravan
Use macro allow you to save multiple objects into a single excel in different cells or sheets. I am facing the same issue with you but still do not find any good solutions. I think you can save the whole sheet as the image without macro.The way is click "File"->"Export"->"Export sheet image" But we cannot do other analyze in the excels anymore, I understand its pretty annoying to copy objects one by one. For more, is it possible to integrate the charts values into one big straight table and export it to excel? Hope it wells.
Hello Sravan
There are a few posts with some suggestions by users for a problem like you describe here:
https://community.qlik.com/message/1055761#1055761
And
https://community.qlik.com/message/646894#646894
Maybe this will help?