7 Replies Latest reply: Nov 27, 2015 10:29 AM by Sunny Talwar RSS

    Creating a new dimension in Qlik Sense

      Hi,

       

      im facing following problem right now:

       

      I got a date_field in may database which marks the date a person left the company.

       

      For example: 

      PersonEnd of duty (Date
      122.01.2015
      223.12.2015
      3

      31.07.2015

      Now i want to retrieve a new data_field which shows how many person already left the company and how many are left.

       

      For example today (27.11.2015) the persons '1' and '3' already left but '2' is still on a running contract.

      Id like to create a new field giving me the information whether the contract is still running or not.

       

      Person End of duty (Date)Status
      122.01.2015left
      223.12.2015running contract
      331.07.2015left

       

      Anyone having an idea how I can achieve this second table? And maybe some hints how to create the expression for it?

       

      Thanks a lot!