topic Cyclic Group Data is numeric but text when sent to Excel in QlikView https://community.qlik.com/t5/QlikView/Cyclic-Group-Data-is-numeric-but-text-when-sent-to-Excel/m-p/1255178#M396722 <HTML><HEAD></HEAD><BODY><P>I had issues with the QlikView to Excel extract but solved that problem with the ini setting on the server <SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> using E</SPAN><SPAN style="color: #3d3d3d; font-size: 10pt; font-family: arial,helvetica,sans-serif;">xcelExportMixedAsText = 0.&nbsp; H</SPAN>owever, it did not solve it for data in a cyclic group.&nbsp; I also changed it in my desktop version and the problem is there as well.&nbsp;&nbsp; I have tried putting NUM() in the script for the data elements but that didn't help either.&nbsp; I suppose I could let the user select with a list box but that defeats the purpose of the cyclic group.&nbsp;&nbsp; Any input would be appreciated.</P></BODY></HTML> Wed, 30 Nov 2016 14:01:08 GMT Anonymous 2016-11-30T14:01:08Z Cyclic Group Data is numeric but text when sent to Excel https://community.qlik.com/t5/QlikView/Cyclic-Group-Data-is-numeric-but-text-when-sent-to-Excel/m-p/1255178#M396722 <HTML><HEAD></HEAD><BODY><P>I had issues with the QlikView to Excel extract but solved that problem with the ini setting on the server <SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> using E</SPAN><SPAN style="color: #3d3d3d; font-size: 10pt; font-family: arial,helvetica,sans-serif;">xcelExportMixedAsText = 0.&nbsp; H</SPAN>owever, it did not solve it for data in a cyclic group.&nbsp; I also changed it in my desktop version and the problem is there as well.&nbsp;&nbsp; I have tried putting NUM() in the script for the data elements but that didn't help either.&nbsp; I suppose I could let the user select with a list box but that defeats the purpose of the cyclic group.&nbsp;&nbsp; Any input would be appreciated.</P></BODY></HTML> Wed, 30 Nov 2016 14:01:08 GMT https://community.qlik.com/t5/QlikView/Cyclic-Group-Data-is-numeric-but-text-when-sent-to-Excel/m-p/1255178#M396722 Anonymous 2016-11-30T14:01:08Z