topic Re: Regarding Calendar in QlikView

Regarding Calendar

Mon, 08 Dec 2014 18:15:53 GMT

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

Re: Regarding Calendar

MarcoWedel — Mon, 08 Dec 2014 18:18:25 GMT

Hi,

maybe creating a canonical date calendar could help:

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

regards

Marco

Re: Regarding Calendar

its_anandrjs — Mon, 08 Dec 2014 20:44:43 GMT

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

Re: Regarding Calendar

Mon, 08 Dec 2014 21:38:24 GMT

Thanks Guys,

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

I appreciate your time in replying!!

Thanks again

Kiru

Re: Regarding Calendar

MarcoWedel — Mon, 08 Dec 2014 23:38:03 GMT

You're welcome.

Please close this thread if there are no further questions.

thanks

regards

Marco