topic Re: Set Analysis "Current Month to Date" Question. in QlikView

Set Analysis "Current Month to Date" Question.

MuraliPrasath — Wed, 29 Jul 2015 08:08:39 GMT

Hi,

I've Current month start variable = vCurrentMonthStart

and Today's date variable = vToday.

Using this how to get the date values in between that is "Current Month to Date"

I tried the following expression please correct me.

sum({1<[PostingDate]={">=$(=date(vCurrentMonthStart) <= $(=date(vToday))"}>} DeliveredQty)

MK_QSL — Wed, 29 Jul 2015 08:12:33 GMT

SUM({<PostingDate = {">=$(=MonthStart(Today()))<=$(=Today())"}>}DeliveredQty)

MK_QSL — Wed, 29 Jul 2015 08:18:18 GMT

Define your vCurrentMonthStart as

=Date(MonthStart(Today()))

Now you can use as below

=SUM({<PostingDate = {">=$(vCurrentMonthStart)<=$(=Today())"}>}DeliveredQty)

tresB — Wed, 29 Jul 2015 08:23:35 GMT

One bracket correction might do the job:

sum({1<[PostingDate]={">=$(=date(vCurrentMonthStart)) <= $(=date(vToday))"}>} DeliveredQty)

sasiparupudi1 — Wed, 29 Jul 2015 09:54:29 GMT

As tresesco says, you are missing a bracket..

sum({1<[PostingDate]={">=$(=date(vCurrentMonthStart)) <= $(=date(vToday))"}>} DeliveredQty)

Make sure that your posting date is in the same format as the dates in your variable.

HTH

Sasi