4 Replies Latest reply: Dec 24, 2013 1:45 AM by Arun Varman

# Set analysis with Maxstring()

Hi All,

Some one help me to know yesterday one interviewer asked this qustion

What is the use of Set analysis with Maxstring()?

Thanks,

Niranjan

• ###### Re: Set analysis with Maxstring()

Hi,

MaxString() will get you the max value in strings, similar to Max() but this is used for strings where Max() is used for Numeric values.

Like Max() we can also use set analysis in MaxString()

Syntax:

MaxString([{set_expression}][ total [<fld {, fld}>]] expression)

MaxString({<Year={2013}>} ProductName)

Hope this helps you.

Regards,

Jagan.

• ###### Re: Set analysis with Maxstring()

Maxstring is an aggregation function. Hence you can use set analysis here like in any other aggregation functions.

Syntax:

MaxString([{set_expression}][ total [<fld {, fld}>]] expression)

• ###### Re: Set analysis with Maxstring()

yes yesterday interviewer he is also asking same question,

how can i use maxstring is an aggregation function,what is the main purpose

Plz explain me