how to create bubble chart

[#1]

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!

[Anil_Babu_Samineni]

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

Here, It will display name along with Data points

[hector_munoz]

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,

H

[coskunist]

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