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: 
Anonymous
Not applicable

export to excel

Hi

I have an straight table chart when I export that  a  "Network Access" text want to appear at the footer of the chart.It want to come automatically when I press the export to excel button.what I want to do for that whether I want to write any macros or I want make any settings change in the documents.?

Please help..

Thanks in advance

11 Replies
bbi_mba_76
Partner - Specialist
Partner - Specialist

Hi,

without macro I think you have to write the text as total or in the caption...

Anonymous
Not applicable
Author

How can I do that without macro ?

I want that text two lines below the excel report for eg:

If my excel table finishes at A10 means text should come at A12

its_anandrjs

No need of macro you can export without the macro and send to excel by right click.

Not applicable
Author

Sara, your in effect adding a footer which you couldnt do without a macro.  If you want a flat export then right click export to excel if the footer is a requirement create a macro

Anonymous
Not applicable
Author

Yes you are right footer is my requirement can I get any examples for my requirements.

Anonymous
Not applicable
Author

I am not sure without macro I cant able to achieve this...

its_anandrjs

Please explain more about the requirement because it is unclear or another way is you can use N-Printing facilities from qlikview on that you can achieve that type of requirement.

bbi_mba_76
Partner - Specialist
Partner - Specialist

Without a macro you export to excel only the table content.

So you could add to generated row to have the text in excel, or you have to use total/caption, or another element of the table to add something. But you have not so possibility to move the text where you want

With a macro you could copy and paste the second macro

http://luciancotea.wordpress.com/2013/07/18/qlikview-macros-useful-collection/

and then you have to add

objExcel.Cells(r+2,c).Value = "Your text" before the end function

Anonymous
Not applicable
Author

Hi

when I export the table chart it should want to export automatically with a text at a bottom of my chart

Eg :

export.PNG.png

Thanks in advance