Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
thewillemzelluf
Contributor III
Contributor III

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.

View solution in original post