Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Exporting graphics from QlikView to Excel

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

3 Replies
Not applicable
Author

Hi Rob,

Have you got any solution for this.

Please let us know.

Thanks

amars
Specialist
Specialist

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

gyan_srivastava
Contributor III
Contributor III

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.