Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
anna_stockhause
Not applicable

Count IDs between two Dates

Hello Everyone,

I am quite new at Qlik Sense and I am very struggling with the following Problem:

I want to a create HR KPI and count the number of active employees on a each day back in the past.

Therefore I get a ID ([NO_]) and the entrydate ([Eintritt]) and the leaving date ([TDATE]) of each employee from SQL.

If the employee is still active the [TDATE] is tomorrow.

I also tried the following instructions (Counting "active" records between two dates) and it worked out perfectly fine. But I could not handle to change the years into dates.

I am very gratefull if there is someone who can help me solve this !!

If you need more Information lease let me know.

I will upload the Script where it already works with years,