Load visualization in Qlik Data model

[prabir_c]

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 @tresesco @MayilVahanan @sunny_talwar @Anil_Babu_Samineni 

[tresesco]

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.

[prabir_c]

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?

[tresesco · Accepted solution]

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.