topic Re: Month start date in QlikView

Month start date

Tue, 27 Nov 2012 15:38:15 GMT

How to get the month start date for eg:11/01/2012 from a date field?

i am trying to do a MTD trend.

Re: Month start date

kouroshkarimi — Tue, 27 Nov 2012 15:41:56 GMT

=monthstart(yourdatefield) should work?

Re: Month start date

Tue, 27 Nov 2012 15:49:58 GMT

yes that does work is there any way that i could use this and write monthtodate wherein i need the show a trend

eg:

start date:11/01/2012

end date:11/27/2012

do a trend showing all the values, how can i do that?

Re: Month start date

Tue, 27 Nov 2012 16:12:32 GMT

if(month(today())&year(today())=month(Date)&Year(Date),1,0) As MTD_FLAG

Re: Month start date

Wed, 28 Nov 2012 04:56:57 GMT

yes that does work is there any way that i could use this and write monthtodate wherein i need the show a trend

eg:

start date:11/01/2012

end date:11/27/2012

do a trend showing all the values, how can i do that?

Re: Month start date

jagan — Wed, 28 Nov 2012 05:28:13 GMT

HI,

Create a variable for start and end dates like below

vStartDate = MonthStart(Max(DateDimension))

vEndDate = If(MonthName(Max(DateDimension)) = MonthName(Today()), Today(), MonthEnd(Max(DateDimension)))

Now use this variables in expression

=Sum({<DateDimension = {'>=$(=vStartDate)<=$(=vEndDate'}>} Sales)

Hope this helps you.

Regards,

Jagan.

Re: Month start date

Anonymous — Wed, 28 Nov 2012 09:08:10 GMT

Hi,

Are you talking about daily sales trend for a month? Add below condition in your exression and use the date field as a dimension.

monthstart(datefield)=monthstart(today())

Thx,

Satya

Re: Month start date

Thu, 29 Nov 2012 03:51:16 GMT

Yes i need to show consecutive daily month trend where datefiled range is from

month starting to current date.(eg:11/01/2012 to11/28/2012) each every day count(orders).

Re: Month start date

Tue, 04 Jun 2013 16:19:23 GMT

this is the way i got it worked

sum({ <[Received Date]={">=$(=monthstart(date(max([Received Date]))) )<=$(=monthend(date(max([Received Date]))))"}> }[Loan Counter])