Dynamically export Qliksense Frontend table charts

[Aditya_Chitale]

Hi all,

Is there any way to export frontend table charts monthwise in qliksense ? If data reloaded for Jan 2022, frontend table should get dynamically exported after app reload into Jan2022.xlsx format. Similarly when data reloaded for Feb 2022, similar excel should get exported for that month with the name Feb2022.xlsx.

I tried doing this through Nprinting. But the file gets overwritten every time for preceeding months.

Any way to do this without using extension ?

Regards,

Aditya

[rubenmarin]

Hi, if you have NPrinting you should be able to do this using dynamic names for files.

And maybe you need a little help from script creating a flag (variable set to 1 or 0) to check if a file is already created and avoid to overwrite, or better, to tell when a new file should be created, NPrinting can check the variable of this value as a condition to execute the task and crete the new file.

A workaround could be using API with exportData method: https://help.qlik.com/en-US/sense-developer/May2021/Subsystems/APIs/Content/Sense_ClientAPIs/Capabil...

But if you have NPrinting I think it would be easier with NPrinting.

[vidyutverma]

There is another way to do the same without NPrinting that involves using Qlik Engine API to request the Chart or HyperCube data. 

[Aditya_Chitale]

Thanks for the reply.

I already have 60 month wise excels present at a location. Then I am creating a loop to load these excels month on month, I found your solution in Nprinting where we can dynamically name the report. but how can I control the loop in qliksense ? like only one month excel should be executed when the task runs. then again for second task, loop should increment and second month excel should load. That way I can manage export of report in nprinting as well.

Regards,

Aditya

[Aditya_Chitale]

Can you share article/post link ?

Regards,

Aditya

[rubenmarin]

Hi, close to the option to set dynamic names there is also an option to make cycles.

As an example, if the sense app has a calendar, you can create another field that has a NP_YearMonth value, only for the yearMonths you want to iterate. Then configure the report to cycle using this field and it will create a report for each YearMonth.