topic Re: Current Month - Expression Builder in QlikView

Current Month - Expression Builder

Fri, 14 Sep 2012 14:12:36 GMT

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

Re: Current Month - Expression Builder

jonathandienst — Fri, 14 Sep 2012 14:20:05 GMT

Several ways, one being:

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

Hope that helps

Jonathan

Re: Current Month - Expression Builder

Fri, 14 Sep 2012 14:22:25 GMT

Thanks Jonathan,

Any suggestions on how best to approach the quarters scenario?

Re: Current Month - Expression Builder

jonathandienst — Sat, 15 Sep 2012 10:01:44 GMT

You can use QuarterStart() in the same way

Jonathan