topic Re: Load statement for a complex, nested JSON-file in App Development

Load statement for a complex, nested JSON-file

der_buschdoktor — Thu, 05 Jun 2025 12:01:20 GMT

Hi ev'ryone,

I'm trying to create a load statement for a json file for the first time in Qlik Sense and ask for your help.
The structure of the json file looks like this:

{
field1:value,
field2:value,
field3:{subfield1:value,
subfield2:value},
field4:value,
field5:[
{subfield_a:value,
subfield_b:value},
{subfield_a:another value,
subfield_b:another value}
],
field6
}

I would appreciate any help you can offer to create a working load statement.

Thank you 🙂

Re: Load statement for a complex, nested JSON-file

NoNameFound — Thu, 05 Jun 2025 14:06:49 GMT

Are you trying to load directly from a file or do you receive the data through the REST connector?

Re: Load statement for a complex, nested JSON-file

rafaelencinas — Thu, 05 Jun 2025 22:00:03 GMT

Hi!

If you are in Qlik Cloud Environment, JSON files are fully supported.

If you are in Qlik Desktop May 2025 patch 1 , its fully supported too.

It makes your work easier !

Bye!

Re: Load statement for a complex, nested JSON-file

der_buschdoktor — Fri, 06 Jun 2025 04:21:32 GMT

directly from a file

Re: Load statement for a complex, nested JSON-file

der_buschdoktor — Fri, 06 Jun 2025 04:24:39 GMT

Hi, we're still on November '24, Patch 8.

Re: Load statement for a complex, nested JSON-file

NoNameFound — Fri, 06 Jun 2025 07:13:32 GMT

Hi Buschdoktor,

you might want to consider upgrading to May 2025, works quite well in the load editor.
See here on how to load json data from a file: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/working-with-JSON.htm

I know it says Qlik Cloud, but it works on premise now, too.

Below I've attached an arbitrary demo file and a screen-cap of how it is loaded in the load editor.

When loading like this, Qlik automatically splits nested data into its own table and connects it to the rest of the data through a hash used as a key.

Re: Load statement for a complex, nested JSON-file

der_buschdoktor — Wed, 11 Jun 2025 09:40:24 GMT

Thanks for your advice. We will uipdate Qlik Sense next week.