Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
maybe creating a canonical date calendar could help:
http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date
regards
Marco
Hi,
maybe creating a canonical date calendar could help:
http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date
regards
Marco
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
Thanks Guys,
I took the Claim_Start date as a base and got the result.
I appreciate your time in replying!!
Thanks again
Kiru
You're welcome.
Please close this thread if there are no further questions.
thanks
regards
Marco