Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How to use calendar for two different excel sheets with different date fields

Hi,

Could you please show me how to use calendar for two different excel sheets with different date fields. I have two excel sheets called, ships and returns with shipdate and returndate respectively. I want to know how to use a calendar for both these date fields. I'd like to know what the script looks like. I have attached both the excel sheets and the calendar qvd i am using.

Thanks,

Joe

1 Reply
mwoolf
Honored Contributor II

Re: How to use calendar for two different excel sheets with different date fields

See Rob Wunderlich's tutorial for using common date dimensions:

Search Recipes | Qlikview Cookbook

Community Browser