
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try this include only those names that are going to be used
If(Match(FieldName, Value1, Value2, FieldName)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What was the logic behind to do this?
May be this
If(Match(FieldName, Value1, Value2, Value3, ....., FieldName)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Would you be able to share a sample to better understand what you are looking to get?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try this include only those names that are going to be used
If(Match(FieldName, Value1, Value2, FieldName)
