topic Re: How to extract 'bubble image' into Excel? in QlikView

How to extract 'bubble image' into Excel?

Fri, 05 Dec 2014 03:58:23 GMT

We created bubble images and those are working great on report. But once we extract that data into Excel, we are missing bubbles. Can someone help us please?

Code we are using for Bubble:

**************************************************************************************

if(sum(DelivQty) >=10 and (sum(DelivQty)<=19),

'qmem://<bundled>/BuiltIn/led_g.png','qmem://<bundled>/BuiltIn/led_r.png')

*************************************************************************************

Sample bubble screenshot also enclosed.

Thanks.

Re: How to extract 'bubble image' into Excel?

sushil353 — Fri, 05 Dec 2014 05:02:07 GMT

Hi ,,

check out this: http://community.qlik.com/thread/80482

HTH

Sushil

Re: How to extract 'bubble image' into Excel?

Fri, 05 Dec 2014 05:36:18 GMT

sushil

We are exporting a Table and Table has bubble images. We would like to get those images with 'Data export'. We are getting 'table data' fine to Excel but 'image column' is missing in excel export (or coming with blank - basically bubbles are not printing).

Your suggested solution will help in exporting whole chart.

Re: How to extract 'bubble image' into Excel?

Sat, 06 Dec 2014 00:20:15 GMT

Any one have a solution for this? We just need to export 'leg.g/r-ping' to excel. Thanks for all your help.

Re: How to extract 'bubble image' into Excel?

MarcoWedel — Sat, 06 Dec 2014 12:15:48 GMT

When exporting a chart's data to Excel, you only get the data.

You can instead copy the charts including the images by copy/paste as image or the object itself.

hope this helps

regards

Marco