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

Announcements
Join us in Toronto Sept 9th 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