Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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)
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
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.