topic qlikview chart to JSON in QlikView

qlikview chart to JSON

mightyqlikers — Mon, 26 Jan 2026 16:26:21 GMT

Dear team,

i have table box or straight table in my qlikview application.

i need to convert this chart data to json file format.

please help me on this.

find the attached for the sample.

Re: qlikview chart to JSON

avinashelite — Mon, 09 Oct 2017 09:37:40 GMT

Could you share the output format your excepting in qlikview ?? you could share the sample format or images etc

Re: qlikview chart to JSON

mightyqlikers — Mon, 09 Oct 2017 09:54:25 GMT

avinash,

required in below format.

{

"test": [{

"id": "500",

"program": "prog003",

"number": "333525",

"datetime": "2017-01-03 15:45:15",

"zone": "north",

"amount": "100"

}, {

"id": "501",

"program": "prog003",

"number": "333526",

"datetime": "2017-01-03 15:48:30",

"zone": "north",

"amount": "300"

}, {

"id": "502",

"program": "prog003",

"number": "333527",

"datetime": "2017-01-03 17:25:23",

"zone": "south",

"amount": "150"

}]

}

Thanks in advance

Re: qlikview chart to JSON

Frank_Hartmann — Mon, 09 Oct 2017 12:23:43 GMT

How much rows do you have in your straight table?

If there are not so much you could try rebuilding the straight table in textbox. (see attached file)

Another possibility, if you have a lot of rows, then you could use a converter (csvtojson)

After creating the CSV file with the STORE statement in script, you could use a script EXECUTE statement to run the CSV-JSON convertor .

hope this helps

Re: qlikview chart to JSON

mightyqlikers — Mon, 09 Oct 2017 12:30:32 GMT

hi,

my actual requirement is to send this straight table or table box data to extension object using javascript.

if you have something.

please share.

thanks in advance.