topic Re: export to excel in QlikView

export to excel

Anonymous — Mon, 28 Apr 2014 13:02:52 GMT

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

Re: export to excel

bbi_mba_76 — Mon, 28 Apr 2014 13:07:46 GMT

Hi,

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

Re: export to excel

Anonymous — Mon, 28 Apr 2014 13:15:49 GMT

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

Re: export to excel

its_anandrjs — Mon, 28 Apr 2014 13:17:47 GMT

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

Re: export to excel

Mon, 28 Apr 2014 13:20:11 GMT

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

Re: export to excel

Anonymous — Mon, 28 Apr 2014 13:26:42 GMT

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

Re: export to excel

Anonymous — Mon, 28 Apr 2014 13:27:23 GMT

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

Re: export to excel

its_anandrjs — Mon, 28 Apr 2014 13:31:14 GMT

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.

Re: export to excel

bbi_mba_76 — Mon, 28 Apr 2014 13:34:26 GMT

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

Re: export to excel

Anonymous — Mon, 28 Apr 2014 13:47:14 GMT

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

Eg :

Thanks in advance

Re: Re: export to excel

mdmukramali — Mon, 28 Apr 2014 13:54:52 GMT

Dear Sara,

one work around by using current selection.

kindly find the attached.

Thanks,

Mukram.

Re: export to excel

Anonymous — Mon, 28 Apr 2014 14:12:55 GMT

Thanks, but can we able to remove that

Selection Status:

word from the footer I dont want that part..