Calculation of specific quarter dates

Anonymous — Fri, 28 Apr 2017 11:15:14 GMT

Hello,

I try to calculate specific quarter dates for a filter.

For example, if I run the report within the first 9 days of a quarter I want to filter automatically the previous quarter and from the 10th day the current quarter should be selected. I want to use this filter in NPrinting for a Report distribution...

I found already an example which is working almost as whished by selecting a specific date:

Ceil( Month( if(Day(DATE)>9,DATE,QuarterStart(DATE,-1)) )/3) as Quarter,

Or by selecting the current day:

Ceil( Month( if(Day(today())>9,today(),QuarterStart(today(),-1)) )/3) as TODAY_Quarter

The problem with these examples is, if I select e.g. the 8th May or the 8th June, the function is also selecting the previous quarter.

But I want only within the first 9 days of the quarter (e.g. from the 1st March until the 9th March) the previous quarter selected. From the 10th March until the quarter end (31th March) the current quarter should be selected.

Has anyone an idea?

Many thanks in advance and best regards,

Claus

Re: Calculation of specific quarter dates

marcus_sommer — Fri, 28 Apr 2017 13:20:44 GMT

Try this: ceil(month(DATE - 9) / 3) as Quarter

- Marcus

Re: Calculation of specific quarter dates

Anonymous — Tue, 02 May 2017 06:52:26 GMT

Many thanks Marcus,

The solution works perfect!

Best regards,

Claus

topic Re: Calculation of specific quarter dates in QlikView

Calculation of specific quarter dates

Re: Calculation of specific quarter dates

Re: Calculation of specific quarter dates