mongodb - Qlikview to display json data of mongo Db in Qlikview -
i new qlikview , have 2 tables in second table storing values in form of array .now want array fields displayed fields
following 2 tables getting mongodb
calling_circles:test_id--
xxxxxxxxx(its mobile number)
calling_circles:text_contacts(here have number on whom mobile number above has contacted , characteristics)--
[{ "msisdn" : "xxxxxx", "date" : "2013-03-02", "incoming_count" : 0, "outgoing_count" : 11, "total_count" : 11, "is_xx" : "y" }, { "msisdn" : "xxxxxx", "date" : "2013-03-02", "incoming_count" : 12, "outgoing_count" : 12, "total_count" : 24, "is_ee" : "y" }, { "msisdn" : "xxxxxxx""date" : "2013-03-02", "incoming_count" : 0, "outgoing_count" : 19, "total_count" : 19, "is_ee" : "n" }, { "msisdn" : "xxxx"date" : "2013-03-02", "incoming_count" : 0, "outgoing_count" : 17, "total_count" : 17, "is_ee" : "n" }, { "msisdn" : "xxxxxx", "date" : "2013-03-02", "incoming_count" : 16, "outgoing_count" : 16, "total_count" : 32, "is_ee" : "y" }, { "msisdn" : "xxxxxxxx", "date" : "2013-03-02", "incoming_count" : 15, "outgoing_count" : 15, "total_count" : 30, "is_ee" : "y" }, { "msisdn" : "yyyyyyy", "date" : "2013-03-02", "incoming_count" : 14, "outgoing_count" : 14, "total_count" : 28, "is_ee" : "y" }, { "msisdn" : "yyyyyyyyyyy", "date" : "2013-03-02", "incoming_count" : 0, "outgoing_count" : 10, "total_count" : 10, "is_ee" : "y" }, { "msisdn" : "xxxxxxx", "date" : "2013-03-02", "incoming_count" : 11, "outgoing_count" : 11, "total_count" : 22, "is_ee" : "y" }]
now want bar char should display attributes inside calling_circles:text_contacts against calling_circles:test_id
so once click number in qlikview dashboard calling_circles:test_id bar chart should display msisdn has called , various attributes related it
thanks
did load data in appropriate data model in qlikview?
if not, i'd recommend resolve json data json capable connector qvsource ...
regards stefan
Comments
Post a Comment