topic Pivot to excel in QlikView https://community.qlik.com/t5/QlikView/Pivot-to-excel/m-p/301186#M581468 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have a pivottable with 2 columns, where the first column is in percent and the second is with a traffic light gauge. It has the exakt same calculations so it is the same numbers. </P><P><BR />However, I would like to export the table to excel and get the traffic light gauge symbol to be exported as well. Right now, if I export to excel it looks like this:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="border: 1px solid #000000; width: 620px; height: 121px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>County</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Percent</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Traffic light gauge</STRONG></SPAN></TH></TR><TR><TD>Skåne</TD><TD>67%</TD><TD>67%</TD></TR><TR><TD>Kronoberg</TD><TD>78%</TD><TD>78%</TD></TR><TR><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR></TBODY></TABLE><P></P><P>Instead of having a number in the second column I would like to be able to export the traffic light symbol.</P><P></P><P>Thanks in advance!</P></BODY></HTML> Wed, 14 Dec 2011 19:10:14 GMT Anonymous 2011-12-14T19:10:14Z Pivot to excel https://community.qlik.com/t5/QlikView/Pivot-to-excel/m-p/301186#M581468 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have a pivottable with 2 columns, where the first column is in percent and the second is with a traffic light gauge. It has the exakt same calculations so it is the same numbers. </P><P><BR />However, I would like to export the table to excel and get the traffic light gauge symbol to be exported as well. Right now, if I export to excel it looks like this:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="border: 1px solid #000000; width: 620px; height: 121px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>County</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Percent</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Traffic light gauge</STRONG></SPAN></TH></TR><TR><TD>Skåne</TD><TD>67%</TD><TD>67%</TD></TR><TR><TD>Kronoberg</TD><TD>78%</TD><TD>78%</TD></TR><TR><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR></TBODY></TABLE><P></P><P>Instead of having a number in the second column I would like to be able to export the traffic light symbol.</P><P></P><P>Thanks in advance!</P></BODY></HTML> Wed, 14 Dec 2011 19:10:14 GMT https://community.qlik.com/t5/QlikView/Pivot-to-excel/m-p/301186#M581468 Anonymous 2011-12-14T19:10:14Z Pivot to excel https://community.qlik.com/t5/QlikView/Pivot-to-excel/m-p/301187#M581469 <HTML><HEAD></HEAD><BODY><P>What you can do is to go to properties, tab title, in section special icons, select copy image to clipboard, then open an excel sheet and paste it. you will have it like an image, I don´t think that is possible to get in excell a gauge into a excel cell.</P><P></P><P>I hope this is what you are looking for.</P><P></P><P>greetings!!</P></BODY></HTML> Wed, 14 Dec 2011 23:45:15 GMT https://community.qlik.com/t5/QlikView/Pivot-to-excel/m-p/301187#M581469 2011-12-14T23:45:15Z Pivot to excel https://community.qlik.com/t5/QlikView/Pivot-to-excel/m-p/301188#M581470 <HTML><HEAD></HEAD><BODY><P> Thanks! But that wasn't what I was looking for <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P>Do you know if it's possible to choose which columns I want to export?</P></BODY></HTML> Thu, 15 Dec 2011 08:36:50 GMT https://community.qlik.com/t5/QlikView/Pivot-to-excel/m-p/301188#M581470 Anonymous 2011-12-15T08:36:50Z