Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

NavinReddy
Contributor II

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

4 Replies
MVP
MVP

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.

MVP
MVP

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)

NavinReddy
Contributor II

Re: Set analysis with Maxstring()

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

Not applicable

Re: Set analysis with Maxstring()

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.

Community Browser