Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
simospa
Partner - Specialist
Partner - Specialist

Export to JSON format?

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

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

-Rob

View solution in original post

7 Replies
Anonymous
Not applicable

Hi Simon,

Did u get the answer for it.

simospa
Partner - Specialist
Partner - Specialist
Author

Hi Erika,

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

S.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

-Rob

fcecconi
Partner - Creator III
Partner - Creator III

Rob

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

~Frank

majdi14789
Contributor III
Contributor III

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Contributor III
Contributor III

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,