Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Chart Title to be displayed in Excel while downloading chart from Qlikview

Dear Qlikview Gurus,

We are downloading our charts into excel format , it is giving expected result i.e dimensions and expression values as per the chart but we need chart title also to be displayed in Excel while downloading  which is not happening currently.

Please share your valuable suggestions.

Thanks in advance.

Regards,

Kishore.

7 Replies
trdandamudi
Honored Contributor

Re: Chart Title to be displayed in Excel while downloading chart from Qlikview

See if the below link can be helpful...

How to export to Excel include Title Caption?

Not applicable

Re: Chart Title to be displayed in Excel while downloading chart from Qlikview

Hi thirumala,

thank you very much for your response ,

as we already know macros behave crazily in Access point ,so we are not allowed to use macros..

any other way to achive this wiht out using macros.

Best Regards,

Kishore

trdandamudi
Honored Contributor

Re: Chart Title to be displayed in Excel while downloading chart from Qlikview

If "Image" is ok then it can be done. Meaning you can copy the qlikview chart as image to Excel and it will retain the heading. Let me know...

tcullinane
Contributor II

Re: Chart Title to be displayed in Excel while downloading chart from Qlikview

We generally tick the 'Show title in chart' option in the general chart properties rather than displaying the caption bar. It can then be formatted nicely and will export as part of the chart

Not applicable

Re: Chart Title to be displayed in Excel while downloading chart from Qlikview

Hi Thomas ,

Thansk alot for the response.

tried the same but not working as expected.

unchecked  the option in general tab and Showing the caption from caption tab, but it is also not working as Expected.

Please elaborate more, or let me know if we missed any thing.

Best Regards,

Kishore

tcullinane
Contributor II

Re: Chart Title to be displayed in Excel while downloading chart from Qlikview

When you say not working as expected what is expected? a screenshot might be helpful.

The charts you are trying to export, are they graphs - line charts/bar charts/etc or tables - straight table/pivot?

how are you exporting from the access point - send to excel, copy image ?

Re: Chart Title to be displayed in Excel while downloading chart from Qlikview

Hey,

My Graphs are perfect with Title...

PFA.

Help

Life is so rich, and we need to respect to the life !!!
Community Browser