topic Load visualization in Qlik Data model in QlikView

Load visualization in Qlik Data model

prabir_c — Fri, 11 Jun 2021 10:48:29 GMT

Hi Team,

I want to export a chart data (front end) into a specific folder everyday in excel format without macro.

for example, I have a sample application 'Sale_App' and a calculated report 'Sales_Performace' (Chart ID: CH01)

Can I reference this chart in script and export it in excel format everyday after reload?

Any suggestions pls (For Qlikview/Sense).

@avinashelite @tresB @MayilVahanan @sunny_talwar @Anil_Babu_Samineni

Re: Load visualization in Qlik Data model

tresB — Fri, 11 Jun 2021 10:56:14 GMT

No the chart object can't referred in script. However, if it's a tabular chart, you can create a temporary table in the script store that in csv format from script.

Re: Load visualization in Qlik Data model

prabir_c — Fri, 11 Jun 2021 11:04:55 GMT

Hi Teresco,

Thanks for the reply!

I am able to generate full data and store it in excel but that's not my requirement. So, I have to use macro in qlikview. What to do for Qliksense?

Re: Load visualization in Qlik Data model

tresB — Fri, 11 Jun 2021 12:40:17 GMT

If you are thinking of automating the process, I guess you could look into few possible options, like : NPrinting, API solution, or a third party/in-house tool.