Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
berryandcherry6
Creator II
Creator 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

1 Solution

Accepted Solutions
sunny_talwar

May be this:

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

View solution in original post

3 Replies
miguelbraga
Specialist III
Specialist III

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
Master III
Master III

may be this

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

sunny_talwar

May be this:

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