Discussion board where members can get started with QlikView.
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))
Do you have date field? If that, then we can try