Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content
Announcements
Gartner® Magic Quadrant™: 15 YEARS A LEADER - GET THE REPORT
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.