Max month in count expression in qlik sense

[Anonymous]

hi All,

can any one help to apply Max(Month) in my qlik sense count expression. Means instead of mentioning MONTH='Jun' i need to apply MONTH=Max(MONTH).

Count(if (MONTH='Jun', [FieldA]) )

thanks in advance

[Gysbert_Wassenaar]

How was the MONTH field created? Is it a text only field or does num(MONTH) return a number? If it does you can try count({<MONTH={"=Num(MONTH)=$(=Max(MONTH))"}>} FieldA)

[tresesco]

And, if your Month field has text values, you could try like:

=Count({<MONTH={"$(=Month(Max(Date#(MONTH,'MMM'))))"}>}FieldA)