MaxValue if date is string

Peony — Wed, 25 Nov 2020 16:16:04 GMT

Hello. Again, I have question about date.

I have field "MonthY" with date values in string view:"MonthName&space&YYYY" . Need to create trigger on document open to select max date in this field. Using =maxString({1} [MonthY]) not good idea, because result is Sep 2017 instead Oct 2017.

Tried this variant =maxString({1} Num(Month(Date#(mid([MonthY],1,3),'MMM')))&mid([MonthY],4,5)), but again it not works.

MonthY

Sep 2016

Sep 2017

Sep 2015

Sep 2014

Sep 2013

Oct 2017

Oct 2016

Oct 2015

Oct 2014

Oct 2013

Nov 2016

Nov 2015

Nov 2014

Nov 2013

May 2017

May 2016

May 2015

May 2014

May 2013

Mar 2017

Re: MaxValue if date is string

antoniotiman — Mon, 20 Nov 2017 10:20:35 GMT

Try this

MaxString(Date#(MonthY,'MMM YYYY'))

Re: MaxValue if date is string

Peony — Mon, 20 Nov 2017 10:40:51 GMT

Oh! Thanks! It's almost what i need. I've just added {1} before Date#. Thank you for simplified idea instead my complex formula.

topic Re: MaxValue if date is string in QlikView

MaxValue if date is string

Re: MaxValue if date is string

Re: MaxValue if date is string