topic Calendar Logic in QlikView

Calendar Logic

abhaysingh — Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys,

Pls find the attached calendar qvd, in this i have continuous dates in it, what i want is right now i am @ 27 May 16,

I want to calculate no of days of current month till Date.

As per todays days 27 May 16, No of Days should be 27

pls suggest ho i can handle the continuous dates ,, i m getting 31

Re: Calendar Logic

sunny_talwar — Fri, 27 May 2016 10:08:05 GMT

Why do you need a calendar to do that. Have you tried this -> Day(Today())

Re: Calendar Logic

abhaysingh — Fri, 27 May 2016 10:11:32 GMT

Hi,

bcoz if i will select last month than it will not give me total no of days of that month.

any suggestion as per calendar dates?

Re: Calendar Logic

Kushal_Chawda — Fri, 27 May 2016 10:11:39 GMT

try

Day(Date) as Days

floor(Date)-floor(monthstart(Date)) as Days

Re: Calendar Logic

sunny_talwar — Fri, 27 May 2016 10:12:48 GMT

I guess try what Kush mentioned

Day(Date)

and on the front end just use Max(Day) based on your selection of Month it should change.

Re: Calendar Logic

abhaysingh — Fri, 27 May 2016 10:25:37 GMT

But i am not getting 27 days..getting 30 in may

Re: Calendar Logic

sunny_talwar — Fri, 27 May 2016 10:28:43 GMT

May be try like this:

If(Today() >= Date, Day(Date), Day(Today()) as ModifiedDay

Re: Calendar Logic

Fri, 27 May 2016 12:09:28 GMT

HI,

Check the attached

It may work

temp:

LOAD [Calendar Date],

link_Date,

Days,

Weeks,

WeekDays,

[Week Start],

[Week End],

[Calendar Year],

[Calendar Month],

[Fiscal Month Num],

[Calendar Month Num],

[Fiscal Quarter],

[Fiscal Year],

[FY Year Name],

[Month Start],

[Month End],

[Quarter Start],

[Quarter End],

[Fiscal YYYYMM],

[Calendar Month Year],

[Fiscal Month]

FROM

[..\Downloads\Stage2_Calendar.qvd]

(qvd);

twef:

LOAD count(if(MonthName([Calendar Date])=MonthName(Today()),[Calendar Date])) as countdays

Resident temp where [Calendar Date]<=Today();