Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Question on maxstring function


Hi All, I have a text field OPENWEEK with the following values ('2013-1'.....upto '2013-45')

I am using a variable RaisedWK =maxstring(OPENWEEK) which returns '2013-9' as the maxvalue

How to tweak the maxstring function to get 2013-45 has the max value?

This is the expression which i am using in the straight table Count(if(OPENWEEK=RaisedWK,Number))

Tags (1)
1 Reply
Sokkorn
Honored Contributor

Re: Question on maxstring function

Hi Basanth,

Do you have date field? If that, then we can try

RaisedWK=Only({$<[DateField]={$(=Max([DateField]))}>} [OPENDWEEK])

Regards,

Sokkorn