topic Re: how to create bubble chart in QlikView

how to create bubble chart

Wed, 25 Nov 2020 16:16:04 GMT

Hi there

With the attached excel sample, how can i create a bubble chart as in the link example in Qlikview?

http://www.trademap.org/Country_SelProductCountry_Graph.aspx?nvpm=1|156||||07|||2|1|1|2|1|1|2|1|1

Thanks!

Re: how to create bubble chart

Anil_Babu_Samineni — Fri, 03 Mar 2017 03:53:06 GMT

May be use dual([POD REGION] & Chr(10) & Sum(Y2017) , Sum([% Chng]))

Here, It will display name along with Data points

Re: how to create bubble chart

hector_munoz — Fri, 03 Mar 2017 07:43:40 GMT

Hi Kok,

If you mean with labels in each bubble, follow Anil's indications; but if you mean with size and colours, consider that you only have 2 measures: 'Y2017' and '% Chng' and you would need 4 at least: Y axis, X axis, size and colour...

Regards,

Re: how to create bubble chart

coskunist — Fri, 11 Jan 2019 10:36:10 GMT

Hello,

Can you help me? I want also to extract data from trademap.org.

How can I access to next pages from URL? I want to get all the data of the search result.

http://www.trademap.org/Country_SelProductCountry_Graph.aspx?nvpm=1|156||||07|||2|1|1|2|1|1|2|1|1

Thanks