Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
thewillemzelluf
Creator
Creator

Add new dimension

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

1 Solution

Accepted Solutions
ajsjoshua
Specialist
Specialist

Dear Willem,

If([employee form]='*holi*','Employee local employment agency',if([employee form]='*lime*','Employee national temporary employment agency','Direct employee'))



Regards,

Joshua.

View solution in original post

2 Replies
timpoismans
Specialist
Specialist

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.

ajsjoshua
Specialist
Specialist

Dear Willem,

If([employee form]='*holi*','Employee local employment agency',if([employee form]='*lime*','Employee national temporary employment agency','Direct employee'))



Regards,

Joshua.