Export to JSON format?

[simospa]

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

[Anonymous]

Hi Simon,

Did u get the answer for it.

[simospa]

Hi Erika,

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

S.

[rwunderlich · Accepted solution]

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

-Rob

[fcecconi]

Rob

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

~Frank

[majdi14789]

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

[rwunderlich]

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

[majdi14789]

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,