topic Downloading visualization from the Load Script in App Development

Downloading visualization from the Load Script

Anonymous — Wed, 27 Sep 2017 13:41:15 GMT

Hi guys,

Is there a way to download visualization from the load script? Can it be .xlsx format?
I am open for any tips and tricks.

Regards,

Todor

Re: Downloading visualization from the Load Script

Anonymous — Wed, 27 Sep 2017 13:53:38 GMT

No - But you can use the Store command in the script to write a table not only to a qvd, but also to a text file.

Have a look at this Blog Post https://www.quickintelligence.co.uk/write-csv-qlikview-store/ by stevedark‌. Whilst it was written for QlikView all the load script concepts are valid for Qlik Sense.

Re: Downloading visualization from the Load Script

Anonymous — Wed, 27 Sep 2017 14:13:09 GMT

Yes, but I want to save edited information, not a raw data. Isn't there a workaround using batch file?

Re: Downloading visualization from the Load Script

Anonymous — Wed, 27 Sep 2017 14:23:56 GMT

Not sure what you mean by edited information in relation to the Load Script.

Re: Downloading visualization from the Load Script

Anonymous — Wed, 27 Sep 2017 14:49:48 GMT

I mean visualization, which shows analyzed(edited) information.

Re: Downloading visualization from the Load Script

Anonymous — Wed, 27 Sep 2017 14:52:39 GMT

In that case no can do as the Load Script has no concept of visualizations. It merely does the ETL to create the data model.

Re: Downloading visualization from the Load Script

stevedark — Wed, 27 Sep 2017 21:29:40 GMT

Thanks for sharing, Bill.

Re: Downloading visualization from the Load Script

stevedark — Wed, 27 Sep 2017 21:33:27 GMT

Hi Todor,

You probably want to be looking at this plug-in for Sense by akl‌ :

GitHub - mindspank/chartcacher: This module will cache charts, render the chart as an image to allow static offline acce…

It's not an official supported Qlik component, but Alex is a Qlik staffer (and development legend) so it's about as close to being official as you can get (without legal getting involved).

Hope it works for you.

Re: Downloading visualization from the Load Script

tomovangel — Thu, 28 Sep 2017 08:31:53 GMT

Hello, Todor

What exactly are you looking for?

Because if you want something like a Straight table, or a Pivot chart, you probably want to export them after Selections are made, and the data is filtered.
If that is the case, you probably have to build extension, in which you define the object and it exports it to a specific folder.
you can check Qlik Branch

and The world's leading software development platform · GitHub

Greetings,
Angel