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.?
Thanks in advance
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
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
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.
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
and then you have to add
= "Your text" before the end function