Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Winter255
Contributor II
Contributor II

Load specific json data to qlik

Hello Gents,

Having issues trying to implement the following solution for json file load:

https://community.qlik.com/t5/QlikView-App-Development/Qlikview-and-Json-api/m-p/798923#M282134

I have json file structure such as:

{
"SoldItems": [
{
"ItemId": 1137722,
"exRate": 0.1788,
"exRate2": 0.5541,
"snp": 0.014
},
{
"ItemId": 1137723,
"exRate": 0.1388,
"exRate2": 0.5341,
"snp": 0.013
},
{
"ItemId": 1137724,
"exRate": 0.1668,
"exRate2": 0.5555,
"snp": 0.015
}


............
]
}

 

Could you please suggest the right solution to get the following outcome:

table with 4 columns  ItemId, exRate, exRate2, snp

Labels (1)
1 Solution

Accepted Solutions
Winter255
Contributor II
Contributor II
Author

1 Reply
Winter255
Contributor II
Contributor II
Author