topic Set analysis with Maxstring() in QlikView

Set analysis with Maxstring()

NavinReddy — Tue, 24 Dec 2013 04:39:42 GMT

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 — Tue, 24 Dec 2013 05:04:18 GMT

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.

tresB — Tue, 24 Dec 2013 05:04:47 GMT

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 — Tue, 24 Dec 2013 05:10:50 GMT

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

Tue, 24 Dec 2013 06:45:03 GMT

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.