Disgard

[#1]

Good morning, I'm suffering to set up a disregard table, how it should work. Company 1 has the customer x, and he purchases y products, I want to disregard some products that this customer buys from that company, and in some cases I will disregard all products. I need this function because some customers are also companies, so I need to disregard these purchases between them. I hope you can help me. Thank you for now.

[Anil_Babu_Samineni]

What was the logic behind to do this?

May be this

If(Match(FieldName, Value1, Value2, Value3, ....., FieldName)

[sunny_talwar]

Would you be able to share a sample to better understand what you are looking to get?

[#4]

Obrigado pelo retorno, estou enviando junto alguns print das tabelas do banco,  clientes, produtos, empresas e criei uma tabela desconsidera. O que eu preciso, existem alguns clientes que vou desconsiderar todos os produtos, e alguns eu desconsidero apenas alguns, na tabela desconsidera no campo produto que aparece 0 gostaria de desconsiderar todos. Voces podem observar que as tabelas cliente e produto eu armazeno separando pelo id_company. Não estou encontrando uma maneira de fazer isso funcionar. Espero que possam me ajudar. Faz pouco tempo que comecei a trabalhar com o qlikview, e sei que ele tem bastante funcoes que podem deixar isso de uma maneira descomplicada.

table client:

table company

table product

table disregard

[#5]

Good morning, I'm having trouble creating the script to disregard. What I need, check in the table disregards if you have the client and the product is null, it has to disregard all products, if I have client and product I have to disregard the products that are registered for that client, if it is not in that list, I bring customers and normal product. Any idea how I could proceed to make those comparisons? Thank you for now.

[xyz1 · Accepted solution]

try this include only those names that are going to be used

If(Match(FieldName, Value1, Value2, FieldName)