Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Current Month - Expression Builder

Hi,

Can someone help me please, I want to bring back some filtered data via expression builder for the current months data.  Currently I have the following expression which gives me records for the current day, how do I ammend this for everything within the current month?

=SUM(if([TableOpening.Date Instructions Received]=(Today()),1,0))

I will then want to expand that to quarters if possible?

Thanks in advance

1 Solution

Accepted Solutions
MVP
MVP

Re: Current Month - Expression Builder

Hi

Several ways, one being:

=SUM(if(MonthStart([TableOpening.Date Instructions Received])=MonthStart(Today()),1,0))

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
3 Replies
MVP
MVP

Re: Current Month - Expression Builder

Hi

Several ways, one being:

=SUM(if(MonthStart([TableOpening.Date Instructions Received])=MonthStart(Today()),1,0))

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Re: Current Month - Expression Builder

Thanks Jonathan,

Any suggestions on how best to approach the quarters scenario?

MVP
MVP

Re: Current Month - Expression Builder

You can use QuarterStart() in the same way

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser