topic Re: Export to JSON format? in QlikView

Export to JSON format?

simospa — Tue, 11 Jun 2013 09:03:17 GMT

Hi,

I need to create an app that will use some data that I can extract easily with QV.

Anyone has idea if QV can export tables in JSON format or a way to do this?

Thanks!

Simon

Re: Export to JSON format?

Anonymous — Thu, 10 Jul 2014 11:19:54 GMT

Hi Simon,

Did u get the answer for it.

Re: Export to JSON format?

simospa — Thu, 10 Jul 2014 16:58:34 GMT

Hi Erika,

no, I didn't get the answer... I think it is possible only developing a customized macro 😞

Re: Export to JSON format?

rwunderlich — Thu, 10 Jul 2014 17:21:57 GMT

You might consider exporting to CSV and then using one of the freely available CSV-JSON converters.

-Rob

Re: Export to JSON format?

fcecconi — Wed, 20 Apr 2016 17:49:56 GMT

Rob

With the latest release v12 of Qlikview, is it now possible to data as JSON?

~Frank

Re: Export to JSON format?

majdi14789 — Fri, 26 Aug 2016 15:56:14 GMT

Hello,

Can we convert the file automatically,if yes please how ?

In fact i generate a CSV file every 20 min.

Lot of thanks,

Majdi

Re: Export to JSON format?

rwunderlich — Sat, 27 Aug 2016 05:47:04 GMT

After creating the CSV file with the STORE statement, you could use a script EXECUTE statement to run a CSV-JSON convertor such as https://www.npmjs.com/package/csvtojson

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Export to JSON format?

majdi14789 — Sun, 28 Aug 2016 21:44:36 GMT

Hi Rob,

Thank you for your reply,but the problem is that i work directly in the server and i don't have the permission to install a program to do the conversion,i think that the solution for me is to do the conversion with the batch language and i hope that is easy.

Many thanks,