article Useful Qlikview Javascript for Chrome Ajax client in Member Articles

Useful Qlikview Javascript for Chrome Ajax client

MikeW — Wed, 21 Sep 2022 17:07:35 GMT

These javascript code snippets can be used in the ajax client in Chrome. (not webview since that is IE and making things work in IE is painful)

All of these are wrapped in anonymous function that are immediately called, so they can be used in a button 'open URL' action in the same window like below so you don't have to install any extensions. You have to modify to code to do more things together for it to be useful since single actions can be done without any javascript coding.

1) Download a pivot table or straight table chart object as csv:

Re: Useful Qlikview Javascript for Chrome Ajax client

Nissar — Mon, 23 Mar 2020 23:05:37 GMT

I tried your example for downloading a straight table chart object as csv, but it doesn't work.

I get the following error, when I click "Check" in the Edit Module:

"Expected ';'" and it highlights the following:

let convertObjectDataToCSV = function (data) {

What am I doing wrong?

I want to have a macro button in my QlikView Application, so when the end user clicks on it from the Web View, then he gets a prompt to download a CSV extract of the straight table on any location he wants to.

Re: Useful Qlikview Javascript for Chrome Ajax client

MikeW — Mon, 23 Mar 2020 23:20:47 GMT

It doesn't go into the edit module. You just put it in the url like in the screenshot.

Re: Useful Qlikview Javascript for Chrome Ajax client

erikzions — Fri, 11 Dec 2020 22:46:23 GMT

I am having a hard time using this. Could you please give an example of your code actually doing something? like changing a font or exporting a table? I hope to export a table to txt. If I can get something simple to work... I think I can expand it, but I am stuck.

Thanks

Re: Useful Qlikview Javascript for Chrome Ajax client

MikeW — Fri, 11 Dec 2020 23:41:14 GMT

I added an example qvw exporting a straight table to CSV. Use Chrome and Ajax client, not webview, to try it out. Let me know if it works for you.

Re: Useful Qlikview Javascript for Chrome Ajax client

erikzions — Mon, 14 Dec 2020 19:02:51 GMT

That is so cool!!! it is one step away from being a perfect solution for me. Can it save the file to a folder instead of downloading to the download folder? I don't want it to save to a file on the users machine... I want it to save to a file on the server. This is awesome!!!

Re: Useful Qlikview Javascript for Chrome Ajax client

erikzions — Mon, 14 Dec 2020 20:19:12 GMT

I got it to work with a ServerSideExportEx. Thank you so much for your help! This is cool stuff. Kudos.

Re: Useful Qlikview Javascript for Chrome Ajax client

Senor_Dai — Tue, 19 Jan 2021 10:36:31 GMT

Hi, this is exactly what Im looking for! Thanks so much. Do you have any idea on how to display a modal popup using this method?