Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I would like to add a new dimension. Now it is the case that every employee is classified on the basis of contract forms. There are employees who work directly with us, but also employees who work with us through an employment agency. This difference is made by the 'employee form' dimension.
However, I would like to make a further distinction based on the local employment agency and national employment agency. Employees then fall into the following 3 categories:
- Direct employee
- Employee local employment agency
- Employee national temporary employment agency
the difference between local and national can be filtered by the name (holi = local) (lime = nationaal).
Someone any idea how I can do this in qliksense?
Mvg, Willem van der Plas
Dear Willem,
If([employee form]='*holi*','Employee local employment agency',if([employee form]='*lime*','Employee national temporary employment agency','Direct employee'))
Regards,
Joshua.
Could you give us a short example of the data you have and what your desired output would be?
It's not entirely clear what's in your employee form.
Dear Willem,
If([employee form]='*holi*','Employee local employment agency',if([employee form]='*lime*','Employee national temporary employment agency','Direct employee'))
Regards,
Joshua.