Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

berryandcherry6
Contributor II

Condition to calculate Month to date.

Hi all,

I want to calculate count of signups of Month to Date.What is the condition i could put for calculating Month To Date.

ex:  Count({$<client_id=12>}signups)

Please help me .

Regards,

Supriya

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Condition to calculate Month to date.

May be this:

Count({$<client_id= {12}, Date = {"$(='>=' & Date(MonthStart(Max(Date)), 'DateFieldFormatHere') & '<=' & Date(Max(Date), 'DateFieldFormatHere'))"}>}signups)

3 Replies
miguelbraga
Valued Contributor III

Re: Condition to calculate Month to date.

Hey there,

I think that what you are looking for is something like this:

Count({$< client_id=12, Month={"$(=max(Month))"} >} signups)

Regards,

MB

arulsettu
Honored Contributor III

Re: Condition to calculate Month to date.

may be this

count({< Datefield={">=$(=Num(MonthStart(Max(Datefield))))<=$(=Max(Datefield))"},client_id={'12'}>} signups)

MVP
MVP

Re: Condition to calculate Month to date.

May be this:

Count({$<client_id= {12}, Date = {"$(='>=' & Date(MonthStart(Max(Date)), 'DateFieldFormatHere') & '<=' & Date(Max(Date), 'DateFieldFormatHere'))"}>}signups)