Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Exporting MaxString( ) to excel


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?