topic Re: doubt in expression =count({<MaxString(Month=$(=max(month)), Date=min(Date)),mrNEWFIELDVALUE={'Open'}>}mrID) in QlikView

doubt in expression =count({}mrID)

Fri, 21 Jun 2013 13:18:56 GMT

I am using this expression for getting the start of the month but getting error in expression can anyone guide me on this

=count({<MaxString(Month=$(=max(month)), Date=min(Date)),mrNEWFIELDVALUE={'Open'}>}mrID)

Re: doubt in expression =count({}mrID)

Gysbert_Wassenaar — Fri, 21 Jun 2013 13:25:34 GMT

Try Month={'$(=max(month))'} instead of MaxString(Month=$(=max(month)) and Date={'$(=min(Date))'} instead of Date=min(Date)). If that doesn't work your month probably is a string. In that case you'll have to fix that in the script so your months are numbers (or dual values with a text and a number value). Using the Month() function on a date field is the best way to create a month field.

Re: doubt in expression =count({}mrID)

Fri, 21 Jun 2013 13:28:18 GMT

try this

=count({<Month={"$(=max(month))"}, Date={"$(=min(Date))"},mrNEWFIELDVALUE={'Open'}>}mrID)

Re: doubt in expression =count({}mrID)

Fri, 21 Jun 2013 13:47:44 GMT

=count({<MaxString(Month={'$(=max(month))'}, Date=min(Date)),mrNEWFIELDVALUE={'Open'}>}mrID)

do you suggest this it is not working

and my month field is text it shows Jan Feb Mar......

i crated month from the date which is in this format

YYYY-MM-DD

Re: doubt in expression =count({}mrID)

Fri, 21 Jun 2013 13:49:43 GMT

used it i am getting 0 value for all

=count({<Month={"$(=max(Month))"}, Date={"$(=min(Date))"},mrNEWFIELDVALUE={'Open'}>}mrID)