topic Exporting MaxString( ) to excel in QlikView https://community.qlik.com/t5/QlikView/Exporting-MaxString-to-excel/m-p/304333#M1180444 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a feild (Order Status) that's comprised of two letter status abbreviaitons. This is a "mixed feild" in that it is denoted by letters but has a numerical value as well. This is so we can filter and see those that are complete on the top , and those that are in the begining stages on the bottom ( or vise versa).</P><P>I am using a maxString() function to find the highest (current) order status for each order. However, when I export to excel, the numerical value for the order status is exported , not the two letter abbreviation. I can convert to text in my expesssion but, that takes away the filtering capabiltties. </P><P></P><P>Any thoughts?</P><P></P><P>Thanks!</P></BODY></HTML> Tue, 21 Feb 2012 16:43:08 GMT 2012-02-21T16:43:08Z Exporting MaxString( ) to excel https://community.qlik.com/t5/QlikView/Exporting-MaxString-to-excel/m-p/304333#M1180444 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a feild (Order Status) that's comprised of two letter status abbreviaitons. This is a "mixed feild" in that it is denoted by letters but has a numerical value as well. This is so we can filter and see those that are complete on the top , and those that are in the begining stages on the bottom ( or vise versa).</P><P>I am using a maxString() function to find the highest (current) order status for each order. However, when I export to excel, the numerical value for the order status is exported , not the two letter abbreviation. I can convert to text in my expesssion but, that takes away the filtering capabiltties. </P><P></P><P>Any thoughts?</P><P></P><P>Thanks!</P></BODY></HTML> Tue, 21 Feb 2012 16:43:08 GMT https://community.qlik.com/t5/QlikView/Exporting-MaxString-to-excel/m-p/304333#M1180444 2012-02-21T16:43:08Z