Insert Field when equal to other column multiple values

[patriciousa]

Hi Qlik Community.

I'm here today with what must be a really easy task.

I need to insert a Field but only when is equal to other column values.

Here is my table:

Nombre	Categoría
Manuel Andres	JPE
María del Mar	JPE
Gabriela Susana	Supervisor
Gustavo	Director
Christian	Senior
Damian Uriel	JP
Ramon	Gerente
Hernan	Gerente
Leandro Martin	Senior
Carlos Matias	Senior

I want to insert in my table in Qlik Sense the Column "Nombre" when "Categoría" is equal to JP, JPE and Senior.

I bet this has to be like the easiest thing in Qlik but I can't figure out how to do it.

Thank you in advance.

Regards.

[patriciousa]

Hi Sunny. Can I ask you something... If I want to use the Set Analysis to all my expressions using {<Categoria = {'JPE', 'JP', 'Senior}>}.

How do I do it?

Thank you again.

Regards.

[sunny_talwar]

All your expressions? You can create a variable:

vVar = {<Categoria = {'JPE', 'JP', 'Senior}>}

and then use it something like this -> Sum($(vVar) Sales) or Sum($(=vVar) Sales)

The expression editor might show this as error, but I think one of the two should work.

[patriciousa]

My bad. I wasn't clear enough.

I have a sheet with tables and a bart chart. How can I apply this filter to the entire sheet?

Is it possible?

Thank you.

Regards.