Set analysis with Maxstring()

[NavinReddy]

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

[jagan]

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.

[tresesco]

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)

[NavinReddy]

Hi Thanks for your reply,

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

Thanks in Advance

Niranjan

[#5]

Similar like Max() function, but maxstring() is applied for text string. Also it does have a optional rank parameter.

If we want to find the maximum of your text string It will be useful.