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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Exporting MaxString( ) to excel

Hello,

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).

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.

Any thoughts?

Thanks!

0 Replies