Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
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.