Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
davidm06
New Contributor

accessing a sub field with MongoDB

Hi everyone !

I have connected QLIK to MongoDB using an ODBC driver

I can get/view/manage the values, it works quite fine.

My issue is that one of the field (Info) is containing sub-fields such as ID, Event, Value

{

    "_id" : ObjectId("58dbb7234a4ccc246c000006"),

    "message" : "{\"i\":\"40:6E:60\",\"e\":\"654654\",\"s\":\"TF\"}",

    "@timestamp" : "\"2017-03-29T13:31:15.045Z\"",

    "host" : "IPADDRESS",

    "insertTime" : "1490794275",

    "info" : {

        "id" : "MACADDRESS",

        "event" : "654654",

        "value" : "machannel"

    }

}

I want to get stats on values, for example.

But in QLIK, only INFO is available

is there a solution ? Hope I am clear enough to get solution

thanks

david