Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Enriquemmesteo
Creator
Creator

Time Dimension/Fiscal Year/Master Calendar

Hello ,

Let's say I have 3 date type fields on my data:

-date of requisition

-date of start

-date of end

An entry will have these 3 dates. Now, as an example, these 3 dates could be 09/05/20, 10/06/20, and 11/06/21.

Can I set up in the script a time dimension that allows me to filter all the others by? For example, this date dimension will allow me to filter by 06/20 and show all the entries with any date dimension with that value(06/20) whether it is the date of requisition, of start or end.

Once I have this I could have a master time dimension that allows me to filter by FY for example. Currently, I derive all the date dimensions from a  master calendar that allows me to filter, for example, by date of end.FY, but not FY itself.

Thanks in advance!

Labels (2)
1 Reply
Enriquemmesteo
Creator
Creator
Author

Anyone has a solution for this?