topic Re: Hi master calendar? in QlikView

Hi master calendar?

Fri, 11 Jul 2014 03:39:05 GMT

I have 2 tables and each table having starting date and ending date ?

t1:

load* inline[

starting date,endingdate,

];

t2:

load* inline[

starting date,endingdate,

]; filed names are ame and inside dates are different from each table. so now i want create a master calendar for this ? how ?

can i join this table or concatenate? is there any other way?

Re: Hi master calendar?

jagan — Fri, 11 Jul 2014 03:58:13 GMT

Hi,

Try like this

t1:

load* inline[

starting date,endingdate,

];

Concatenate

load* inline[

starting date,endingdate,

];

Noconcatenate

Calendar:

LOAD DISTINCT

RESIDENT t1;

DROP TABLE t1;

Now create required date field in Calendar table.

Regards,

jagan.

Re: Hi master calendar?

Fri, 11 Jul 2014 04:03:37 GMT

can u give script for this scenario map calendar

Re: Hi master calendar?

Anonymous — Fri, 11 Jul 2014 04:07:20 GMT

Hi,

You can use Concatenate here and since starting date and ending date are different in each table, you can use flag to distinguish them.

Calendar:

load* inline[

starting date,endingdate,

'table1' as table_flag,

];

Concatenate

load* inline[

starting date,endingdate,

'table2' as table_flag,

];

Re: Hi master calendar?

jagan — Fri, 11 Jul 2014 04:10:11 GMT

Hi,

Check this link, hope it helps you.

Master Calendar Generation Script

Regards,

Jagan.

Re: Re: Hi master calendar?

senpradip007 — Fri, 11 Jul 2014 04:12:35 GMT

Try with this qvw.