topic Exporting graphics from QlikView to Excel in QlikView

Exporting graphics from QlikView to Excel

Thu, 25 Feb 2010 19:11:04 GMT

I have a straight table with 4 columns (1 dimension and 3 expressions). One of the expressions is traffic light gauge that indicates a red, yellow, or green light based on how the other two metrics compare against each other. My question is this: When I export the straight table to excel I get something like the below in the cell that the stop light picture was in:

qmem://<dynamicimage>\Document\CH644\3\0\cca6c19ba674f77cbd73a48720b161ab58f170b52e756042abe75b36a9c7f5eb

Is there any way to include the traffic light when I export to excel? My guess is probably not, but I wanted to check anyways just in case.

thanks,

rob

Exporting graphics from QlikView to Excel

Mon, 10 Jan 2011 07:23:33 GMT

Hi Rob,

Have you got any solution for this.

Please let us know.

Thanks

Exporting graphics from QlikView to Excel

amars — Mon, 10 Jan 2011 07:59:26 GMT

Hi Rob,

As far as I understand, whenever u export any chart it's equivalent Table/Pivot format (using fast change) is exported to excel. In ur case why it is getting exported like that I really can not understand. The other way to export is to export the image of the chart. See if the attached example helps.

Thanks

Exporting graphics from QlikView to Excel

gyan_srivastava — Mon, 10 Jan 2011 09:25:00 GMT

Hi Amars ,

I have similar requirement for exporing all grapts and sheets to PPT ,Can you please suggest or give some file to see the sample data.

Can you use Export image & chart .qvw as reference.