Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Disgard

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.

1 Solution

Accepted Solutions
xyz1
Creator III

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

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

View solution in original post

5 Replies
Anil_Babu_Samineni

What was the logic behind to do this?

May be this

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
sunny_talwar

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

Not applicable
Author

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 clients.PNG

table company

table company.PNG

table product

table products.PNG

table disregard

table disregard.PNG

Not applicable
Author

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
Creator III

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

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