Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
omar_1981
Contributor III
Contributor III

mostrar valores excluidos

Hola, tengo una duda con Qlikview, me preguntaba si alguien podria ayudarme.

Sabeis si hay alguna opcion para seleccionar  los valores excluidos en una busqueda? tengo una lista, de la que selecciono un valor, pero tengo una grafica y quiero que la dimension sea los valores excluidos de la busqueda.

Alguien sabe como hacerlo?

Un saludo.

5 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Look at set analysis help and use E option

sum( {$<Customer = E({1<Product={‘Shoe’}>})>} Sales )
returns the sales for current selection, but only those customers that never bought the product ‘Shoe’. The element function E( ) here returns the list of excluded customers; those that are excluded by the selection ‘Shoe’ in the field Product. 

omar_1981
Contributor III
Contributor III
Author

hello.

is a good solution, but mi field is a string. i have 3 strings. "1", "2"and "3". if i select the field "1" and i create a graphic, what sentence i must write to select the fields "2" and "3"??

alexandros17
Partner - Champion III
Partner - Champion III

try with GetFieldSelections() ...

omar_1981
Contributor III
Contributor III
Author

didn't works, because it selects the fields that i have selected, but i want the fields that aren't selected

alexandros17
Partner - Champion III
Partner - Champion III

sum( {$<Customer = E({1<Product={‘$(=GetFieldSelections(MyField))’}>})>} Sales ) ...