Calendar Scenario

[Anonymous]

Hi All,

I am having field called Activity_Date in DB. I need to use this date field (From Date/To Date)as a two separate calendar object.

As I having single field (Activity_Date) how to use in two different Calender Obj.

Thanks,

-Jay

[jyothish8807]

Hi Ij,

Just rename the field and create a new.Call that field in other calander object.

Load

Active_Date,

Active_Date as NewField

From <>

Regards

KC

[Anonymous]

If you really need to be able select independently on both [From Date] & [To Date] via Calendars then you will need two Calendar Tables / Objects in your model.

I'd suggest you double check the requirements as it is quite likely only one of [From Date] & [To Date] will need to be selected on & not both.

[MK_QSL]

Can you please elaborate little more ?

[Anonymous]

Hi All,

Thank you for your replys. Actually I need to view the events which happened in particular activity dates.So I need to check ( Ex : 1st Nov- 15Nov) events during this time period. Here I need to select 1st Nov and 15th Nov in two different

calender object. Its my requirement

-Jay

[maleksafa]

check the below link on canonical date.

http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date

[Anonymous]

If you mean events that exactly started on say 1st Nov and ended on 15Nov, then you will need 2 Calendar tables / objects and to make 2 selections one for start date & one for end date.

[Anonymous]

Hi Bill,

Thats what I am trying. But I am having single DB field.So I cant use same field with two different object.

[Anonymous]

Could share the structure of the DB table ?

[Anonymous]

Hi,

Its single table,I don't have any other date field in the table