topic Re: Fiscal Quarter Issue in QlikView

Fiscal Quarter Issue

Tue, 16 Dec 2014 11:23:32 GMT

Hi Friends,

I have different quarter range, it is basically based on day,for eg

QTR	Start	End
1	11/25	02/16
2	02/17	05/11
3	05/12	08/31
4	09/02	11/24

and I need to map dates in above range,please find the attachment to help me in this

its really urgent.

regards

Bhawna

Re: Fiscal Quarter Issue

Tue, 16 Dec 2014 11:31:15 GMT

please anyone,i really need the solution

Re: Fiscal Quarter Issue

Tue, 16 Dec 2014 12:01:49 GMT

anyone please look into this

Re: Fiscal Quarter Issue

francoiscave — Tue, 16 Dec 2014 12:31:22 GMT

Hi Bhawna,

See the link below:

IntervalMatch

Good luck,

François

Re: Fiscal Quarter Issue

Tue, 16 Dec 2014 12:37:37 GMT

I already applied interval match but didnt work

Re: Fiscal Quarter Issue

Tue, 16 Dec 2014 12:53:32 GMT

I really need the solution or any alternative..

Re: Fiscal Quarter Issue

francoiscave — Tue, 16 Dec 2014 12:55:38 GMT

I try something...

“If there is no solution to the problem then don't waste time worrying about it. If there is a solution to the problem then don't waste time worrying about it.”

François

Re: Fiscal Quarter Issue

tresB — Tue, 16 Dec 2014 12:55:50 GMT

When you write: Date#('02/31','MM/DD'), then year is taken as 1899, that is where it is going wrong. See the modified sample attached.

Re: Fiscal Quarter Issue

anbu1984 — Tue, 16 Dec 2014 12:58:15 GMT

Mstr:

load *,

Date#(Key,'MM/DD/YYYY') as Newkey

;

load * Inline [

Key

02/01/2014,

06/03/2013

];

tab:

load * ,

date#(start,'MM/DD/YYYY') as S,

date#(end,'MM/DD/YYYY') as E;

load * Inline [

ID,start,end

1,11/25/2013,02/16/2014

2,02/17/2014,05/11/2014

3,05/12/2014,08/31/2014

4,09/02/2014,11/24/2014

1,11/25/2012,02/16/2013

2,02/17/2013,05/11/2013

3,05/12/2013,08/31/2013

4,09/02/2013,11/24/2013

];

Inner Join

IntervalMatch(Newkey) LOAD S,E Resident tab;

Re: Fiscal Quarter Issue

Wed, 17 Dec 2014 05:40:36 GMT

thank to all of you I have told the client that it is not possible dynamically..waiting for their response..

Thank you

regards

Bhawna