topic Re: Day Start Expression in QlikView

Day Start Expression

Wed, 03 Jun 2015 07:04:53 GMT

Hi,

Normally a moth will have 30 days or 31 days, for feb [28/29] , and Year will start from 1/Jan/20**, ..

but in my case Year will start from 27/Agu/20**. and moth will hav 28 days only, for this how can I get start date ,End date of every month.

Thanks,

John

Re: Day Start Expression

petter — Wed, 03 Jun 2015 07:08:54 GMT

Many of the date functions has an offset parameter that should work for you. And the month calculation should be simple divisions and multiplications with 28.

Re: Day Start Expression

Wed, 03 Jun 2015 07:25:37 GMT

Thanks Petter Skjoiden.

Re: Day Start Expression

avinashelite — Wed, 03 Jun 2015 07:25:46 GMT

Hi John,

try to build your own custom calendar and define the start date and end , interval range you require

Re: Day Start Expression

Wed, 03 Jun 2015 07:36:59 GMT

Thanks Abvinash R, I tried with inbuilt Qlikview date functions vmindate= Makedate(2012,08,27),

vMaxdate= today()

I have generated a calendar by using those two variables , now I have first dat as 27/Aug/2012

if I applied Monthstart I am getting 01/Aug/2012 , but I don't want it I want to see 27/Aug/2012 AS my month start value. is there a way to get it.

Regards

John

Re: Day Start Expression

sasiparupudi1 — Wed, 03 Jun 2015 12:10:44 GMT

Hi John

Since your requirement is much different to the standard calendar, I think you will have to use workarounds as follows in your expressions

Month Start

= Date(MonthStart(SalesDate)+26)

Month End

=Date(MonthEnd(SalesDate),'YYYY/MM') & '/28'

Good luck,

Sasi