Discussion board where members can learn more about Qlik Sense App Development and Usage.
i want to report company applications in Qlik Sense. In the data model the applications have a start and an end date, which are managed in a seperate table like this:
The tables come from a database, so I have no influence on that.
I want to create a new table, so i can have a year dimension. It would lookk like this:
Application to Year:
How can I create these tables, especially the connection table, within the data editor?
I would appreciate your help!
One way would be to join your start-date and end-date together:
load AppID, Date as [From Date] from Lifecycle where Type = 'Start';
load AppID, Date as [To Date] from Lifecycle where Type = 'End';
and matching them with an IntervalMatch to a master-calendar: How to use - Master-Calendar and Date-Values. Then you will have period fields like a year and could use simple expressions like count(AppID) to get the number per year.