Regarding Calendar

[#1]

Hello Friends,

Kindly help me in my logic. I have to create a calendar based on 2 fields namely Claim_Start and Claim_End. So in the calendar when I click on a date field, the corresponding Claim start and Claim end  period needs to get selected correspondingly.

Kindly share your ideas.

Kind regards,

Kiru

[MarcoWedel · Accepted solution]

Hi,

maybe creating a canonical date calendar could help:

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

regards

Marco

[its_anandrjs]

Hi,

You can create canonical date calendar and you can write some thing

CommonDate:

Load

Claim_Start,

Claim_Start as [date field]

'Claim Start Date' as DateFlag

Resident Source;

Concatenate(CommonDate)

Load

Claim_End,

Claim_End as [date field]

'Claim_End Date' as DateFlag

Resident Source;

MasterCal:

Load

[date field]

...

...

And then create the master calendar based on the [date field] fields from CommonDate table and connect it with master calendar.

Regards

Anand

[#4]

Thanks Guys,

I took the Claim_Start date as a base and got the result.

I appreciate your time in replying!!

Thanks again

Kiru

[MarcoWedel]

You're welcome.

Please close this thread if there are no further questions.

thanks

regards

Marco