Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kanimozhi
New Contributor II

Max month in count expression in qlik sense

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

2 Replies

Re: Max month in count expression in qlik sense

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)


talk is cheap, supply exceeds demand
MVP
MVP

Re: Max month in count expression in qlik sense

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

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

Community Browser