Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. 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