Skip to main content
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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



0 Replies