topic Re: Dates per fortnight in QlikView

Dates per fortnight

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

Hi guys.

I have the following case.

In the company where I do the project, they make payments every fortnight and end of the month. Then you have to create a filter by fortnight and end of month. Example.

I made an example to get fortnights but since the months do not have exactly 30 days, it does not work. Examples.

As shown in the image, filter the year 2017 and fortnight 27, should show the days 16 to 31 and in the fortnight 26 should show the days 1 to 15.

Please help me with this topic.

I attach the qvw.

Greetings.

Re: Dates per fortnight

sunny_talwar — Fri, 04 May 2018 14:44:39 GMT

May be try this

AutoNumber(Month(Date)&If(Day(Date) <= 15, 1, 2)) as Fortnight_New,

Re: Dates per fortnight

olivierrobin — Fri, 04 May 2018 14:51:43 GMT

hello

I would try this :

SET Fortnight = if(day($1)<=15,(month($1)-1)*2+1,month($1)*2);

Re: Dates per fortnight

cristianj23a — Fri, 04 May 2018 15:10:43 GMT

thank you Sunny.

regards.

Re: Dates per fortnight

cristianj23a — Fri, 04 May 2018 15:13:00 GMT

thank you Olivier.

that code also works.

regards.