topic Re: Bubble Matrix Chart in QlikView

Bubble Matrix Chart

akpofureenughwu — Tue, 22 Nov 2016 12:18:17 GMT

Good day everyone,

How can I design a bubble matrix chart on qlikview or qlkisense?

the link below is the design on excel..

https://sites.google.com/site/e90e50fx/home/matrix-bubble-chart-with-excel

I would love to build it on qlikview or qliksense.

kindly find the attached sample file

Re: Bubble Matrix Chart

shraddha_g — Tue, 22 Nov 2016 16:37:04 GMT

Try extension for grid chart in qliksense

Re: Bubble Matrix Chart

MarcoWedel — Tue, 22 Nov 2016 23:00:26 GMT

Hi,

maybe one solution could be:

table1:
CrossTable (YearTemp, Value)
LOAD F1 as Category,
    [2008],
    [2009],
    [2010],
    [2011],
    [2012],
    [2013]
FROM [https://community.qlik.com/servlet/JiveServlet/download/1163835-254604/sample.xlsm] (ooxml, embedded labels, table is [1]);
Join
LOAD Distinct
    YearTemp,
    Num#(YearTemp) as Year
Resident table1;

hope this helps

regards

Marco

Re: Bubble Matrix Chart

shraddha_g — Wed, 23 Nov 2016 04:35:58 GMT

Try Qlik Branch

Re: Bubble Matrix Chart

MarcoWedel — Wed, 01 Mar 2017 19:22:01 GMT

Please close this thread if your question is answered:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco

Re: Bubble Matrix Chart

rammuthiah — Fri, 19 Jan 2018 14:17:42 GMT

Where I can find Bubble Matrix Chart(not Grid Chart) extension for Qlik Sense?