topic Re: Export symbols to Excel in QlikView

Export symbols to Excel

Fri, 12 Dec 2014 13:31:47 GMT

Hi all,

Does anyone know if it is possible to export the symbols shown in attached image in last column can be exported to excel?

when i extract i get last column blank.

please suggest.

thanks a lot

jyothi

Re: Export symbols to Excel

alexandros17 — Fri, 12 Dec 2014 13:33:47 GMT

I think it is not possible ...

Re: Export symbols to Excel

marcus_sommer — Fri, 12 Dec 2014 14:12:13 GMT

If it is an embedded picture it won't work unless you copied it as picture. But if you want only show some status in the shape from colored circles/arrows ... you could use chars like chr(9678) or chr(9650) or similar.

- Marcus

Re: Export symbols to Excel

Fri, 12 Dec 2014 14:54:24 GMT

You would have to 'copy as image' and then paste in Excel manually. You can write a macro to export to Excel and paste as picture as well. I might have an example. Will post.

Re: Export symbols to Excel

Fri, 12 Dec 2014 15:31:26 GMT

Hi Salvatore,

Please post the example.

Thanks a lot

Re: Export symbols to Excel

Fri, 12 Dec 2014 15:53:59 GMT

Hi Jyothi,

I found this just before uploading my app... this should do what you what

http://community.qlik.com/docs/DOC-4315

All the best