topic Re: Need to get Max week in QlikView

Need to get Max week

SatyaPaleti — Fri, 06 Nov 2015 08:12:09 GMT

Hi Friends,

I am having following Data it shows all the weeks in 2015. I want to show max week among that

I am using Max function but it's not working

Here is the attachment & Qvw

Thank you,

Satya

robert_mika — Fri, 06 Nov 2015 08:22:34 GMT

Your data are in String format try

Max(right(Yourfield,2))

(no attachment just screen dump attached)

tresB — Fri, 06 Nov 2015 08:23:31 GMT

Max() won't work here, because your field is a text one. Try MaxString().

Anonymous — Fri, 06 Nov 2015 08:24:16 GMT

try sth like at script level:

=mid(Week,6,7) as Week

and then at UI level like: max(week) or max(mid(Week,6,7))

SatyaPaleti — Fri, 06 Nov 2015 08:36:02 GMT

Here in My Data Max week is 2015-45

How to get that

Anonymous — Fri, 06 Nov 2015 08:37:31 GMT

Try this one :

max(mid(Week,6,7))

Anonymous — Fri, 06 Nov 2015 08:38:40 GMT

If it is into string then:

=max(mid(num(Week),6,7))