Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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"??
try with GetFieldSelections() ...
didn't works, because it selects the fields that i have selected, but i want the fields that aren't selected
sum( {$<Customer = E({1<Product={‘$(=GetFieldSelections(MyField))’}>})>} Sales ) ...