I am still very new and inexperienced in dealing with Qlik. But now I've been working a bit, but would now end up with my still modest Latin.
The following: I have two SQL queries from a system. One about the entrances to the company and in a second query the withdrawals from the company.
Here are my queries:
1) Entries: Select cost Center, cost Center Name, Company Name, entry year, entry month, "total entries per month", month Name
2) Withdrawal: Select cost Center, cost Center Name, Company Name, Exit year, exit month, "total Exit per month", month Name
This is my current calender i tried:
floor(num(??) as %calender_year_employee
At the moment I have created one list for entries and one for exits. Nevertheless, I need one calender for each report (one calender which is linked to the entry year, entry month and the other ones which is linked to the exit year, exit month)
Honestly I would prefer that the people have to select out of one calender and both report-lists will change appropriate.
However, now i dont know what to put in the brackets above (calender) and how to link with my entry year, entry month and exit year, exit month.