Problem with master calendar

[Anonymous]

hi,

I have following table....

work_id     name       startdate                enddate

1                  a        11/01/2014            12/01/2014  

2                  b        11/01/2014            12/01/2014  

2                  c        12/01/2014            13/01/2014  

1                  c        11/01/2014            12/01/2014  

3                  b        13/01/2014            14/01/2014  

4                  c        14/01/2014            15/01/2014  

like consider, i have some 1000 of records, now how do i create a master calendar for these start and end date, are there any other way to do this.?

Thanks..

[Anonymous]

I have two tables. namely

workflow table

task table

workflow table fields.

workflow_id     workflow_name      start_date      end_date

1                         a                     10/02/2014    12/02/2014

task table fields.

workflow_id     task_id     start_date       end_date

1                        1a       10/02/2014     10/02/2014

1                        1b       10/02/2014     11/02/2014 

Here.. each workflow_id has more than one task_id and start and end date...

I want to create a pivot table. where i have to include all these..

I want to create either master cal / canonical date.. To make selections according to d dates it can be either from workflow table or from task table

Thanks..

[Digvijay_Singh]

I think canonical date may work for you, your workflow start/end is diff from task start/end, so they shouldn't associate by keeping diff names. You can use attached sample script, here multiple calendars are also used which can be ignored.

[Anonymous]

Creating multiple calendars for those four date fields will help me.???

can i make a link with those workflows with tasks by creating multiple cals?

[Digvijay_Singh]

I think you need canonical calendar, that way you can link workflow dates and task dates, follow the sample.

[Anonymous]

Hi.. i followed the same and made a link between two tables.

My doubt is, can i also Create multiple master calendars for those four date fields.!! Is that possible?.. if i do that, will it link workflow dates with task dates.??

[Digvijay_Singh]

Indirectly all fields are connected thru IDs but for dates based KPIs u

need one holistic field representing all dates

Thanks and Regards,

Digvijay Singh

On 26 Jul 2016 11:41, "kishore pandurangan" <qcwebmaster@qlikview.com>

[Anonymous]

Hi.. i didn't get how the canonical date works. Can you pls explain with your sample qvw.. In which case we may use this canonical date.!

[rubenmarin]

Hi kishore, in case it helps, here is Canonical Date explained: Canonical Date