topic Re: Disgard in QlikView

Disgard

Mon, 23 Jan 2017 13:46:43 GMT

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.

Re: Disgard

Anil_Babu_Samineni — Mon, 23 Jan 2017 13:49:48 GMT

What was the logic behind to do this?

May be this

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

Re: Disgard

sunny_talwar — Mon, 23 Jan 2017 13:52:07 GMT

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

Re: Disgard

Mon, 23 Jan 2017 14:47:16 GMT

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

Re: Disgard

Tue, 24 Jan 2017 11:06:52 GMT

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.

Re: Disgard

xyz1 — Tue, 24 Jan 2017 12:17:03 GMT

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

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