topic Re: Calendar Scenario in QlikView

Calendar Scenario

Anonymous — Wed, 05 Nov 2014 15:41:11 GMT

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

Re: Calendar Scenario

jyothish8807 — Wed, 05 Nov 2014 15:45:44 GMT

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

Re: Calendar Scenario

Anonymous — Wed, 05 Nov 2014 15:45:51 GMT

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.

Re: Calendar Scenario

MK_QSL — Wed, 05 Nov 2014 15:46:02 GMT

Can you please elaborate little more ?

Re: Calendar Scenario

Anonymous — Wed, 05 Nov 2014 15:51:31 GMT

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

Re: Calendar Scenario

maleksafa — Wed, 05 Nov 2014 15:51:37 GMT

check the below link on canonical date.

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

Re: Calendar Scenario

Anonymous — Wed, 05 Nov 2014 15:59:31 GMT

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.

Re: Calendar Scenario

Anonymous — Wed, 05 Nov 2014 16:14:50 GMT

Hi Bill,

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

Re: Calendar Scenario

Anonymous — Wed, 05 Nov 2014 17:12:03 GMT

Could share the structure of the DB table ?

Re: Calendar Scenario

Anonymous — Wed, 05 Nov 2014 17:14:26 GMT

Hi,

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

Re: Calendar Scenario

Anonymous — Wed, 05 Nov 2014 17:19:23 GMT

Without seeing the DB structure it is impossible to guess what on earth you are trying to make do what.

Re: Calendar Scenario

Anonymous — Wed, 05 Nov 2014 17:27:33 GMT

Thank You Bill

Re: Calendar Scenario

djsampat — Thu, 06 Nov 2014 01:49:36 GMT

Hi,

Why dont you try making a MonthYear field like Month(ActivityDate)&Year(ActivityDate) as MonthYear and then you can select a range from 012014 to 122014 being Jan to Dec 2014.

See this blog post for the answer: Creating Reference Dates for Intervals

I prefer to use 2 seperate variables. one for Start Date and another for End Date and Do the comparison of the dates in the expressions using set analysis

Sum({<selected_date={'>= $(vStartDate) <=$(vEndDate)'}>}Measurename)

If this helped you, please mark as Helpful. If it solves your issue, please mark as Answer

Regards

Dhruv

Re: Calendar Scenario

Anonymous — Thu, 06 Nov 2014 03:25:39 GMT

Hi All,

I was ref and able to find out the way to achieve the same. Kindly have a look and let me know any other optios

-Jay