topic Re: Maxstring??? in QlikView

Maxstring???

Tue, 20 Aug 2013 09:29:48 GMT

Good morning all,

This might be a silly question...but hey!

I have a script that I am using, but the script is written by someone else.

Can someone please explain the use of maxstring to me?

I am still new at Qlikview and don't know all the terminology and use thereof.

Thank you

*R*

Re: Maxstring???

Tue, 20 Aug 2013 09:33:29 GMT

The Maxstring function just picks the maximun string value on a list of Strings. For example:

Maxstring(alphabet) would return 'Z', taking into acount that alphabet is a field that contains all the letters of the alphabet. Simple.

Re: Maxstring???

tresB — Tue, 20 Aug 2013 09:39:30 GMT

In SCRIPT (from help):

Returns the last text value of expression over a
number of records, as defined by a group by clause. If
no text value is found, NULL is returned.

Example:

Load Month, MaxString(Month) as LastSalesMonth from abc.csv group
by Year;

Re: Maxstring???

khadeer — Tue, 20 Aug 2013 09:46:21 GMT

Hi,

PFA. It helps you regarding string functions and examples.

Regards,

Khadeer

Re: Maxstring???

Tue, 27 May 2014 09:35:25 GMT

All you've done is copy a chunk from the QlikView Reference manual. This doesn't help us QlikView beginners at all. How about explaining in plain English with a good, clear and simple example which can be understood by those who are new to QlikView.

Re: Maxstring???

ThornOfCrowns — Tue, 27 May 2014 09:43:15 GMT

To be fair, the reply by tresesco does exactly what you ask, it explains the function, gives an example and guides the OP to the relevant part of the Help file.

What more would you want in an answer to a question practically a year old?

Re: Maxstring???

Anonymous — Tue, 27 May 2014 09:50:43 GMT

Hi,

maxstring gives you the string that is last in the ascending list of strings

HTH

Ravi N.

Re: Maxstring???

tresB — Tue, 27 May 2014 09:52:54 GMT

I don't agree. Reference manual doesn't help biginners ! I believe that's the best place to start with. However, let me try to put it in a different way (might not be a simpler one).

Two cases of uses:

Front-end chart:

Returns the maximum string(as the sort is considered here is 'text') from a lot of records.

Script:

Returns the last text value from a lot of records that come under a group depending on group by clause.

This would be clearer to you once you try and see the outcome in practical. Create a sample qvw and play with it.

Re: Maxstring???

jonathandienst — Tue, 27 May 2014 10:03:11 GMT

perhaps this illustrates the difference between Max and MaxString

HTH

Jonathan

Re: Maxstring???

jonathandienst — Tue, 27 May 2014 10:05:44 GMT

And for a dual value, both Max and Maxstring return the highest numerical field value. Max return the numerical value of the field and MaxString returns the text representation of the same field value.

Re: Maxstring???

Tue, 27 May 2014 11:40:05 GMT

That's great. A simple but clear example. Thank you

Re: Maxstring???

Tue, 27 May 2014 13:11:44 GMT

Experienced QlikView techies might like to consider those of us who are not comfortable or experienced enough to use the Reference Manual with confidence.

I always try to get my answers from the QV Reference Manual first but if I don't understand the syntax then I post a discussion. So, being shown an exact copy of the Reference Manual syntax isn't going to help me. All I ask for is a clear, simple explanation with an example, if possible.

Otherwise, if the Reference Manual was the answer to all our enquiries we wouldn't need a forum for you clever techies !

Regards

Re: Maxstring???

Thu, 11 Dec 2014 08:45:51 GMT

Hi,

Can I ask on the maxstring function, it is incorrect to just put =MaxString(data) in my pivot table to get my result ?

Although this show the numeric and string that are in the records.