Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Dates

Hello,

I need to extract from my calendar the last sunday of the month

how can i do this?

tnks!

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Dates

May similar to this?

TempCalendar:

LOAD Date(makedate(2013)+recno()) as TempDate

AutoGenerate 500;

Calendar:

LOAD *, weekday(LastSunday) as Test;

LOAD Date(max(if(weekday(TempDate)=6,TempDate))) as LastSunday

Resident TempCalendar

group by monthstart(TempDate);

2 Replies
MVP
MVP

Re: Dates

May similar to this?

TempCalendar:

LOAD Date(makedate(2013)+recno()) as TempDate

AutoGenerate 500;

Calendar:

LOAD *, weekday(LastSunday) as Test;

LOAD Date(max(if(weekday(TempDate)=6,TempDate))) as LastSunday

Resident TempCalendar

group by monthstart(TempDate);

Not applicable

Re: Dates

Tnks Swuehl!!

Community Browser