topic Re: Restas condicionadas in QlikView

Restas condicionadas

Anonymous — Thu, 19 May 2016 15:46:08 GMT

Friends;

I would ask your help for the next case.

I have a table that comes with the following columns documnet Type, Units, Invoice, now well what I do is subtract units Units when Document Type ZRE and ZVLO have the same number of Invoice.

Document Type Invoice Units

ZVLO April 1234

ZRE February 1234

In this case subtracting 4 ZVLO 2 ZRE but the condition is the same as is Invoice example.

I really appreciate your help much because I failed to do so.

Regards.

-------------------

Amigos;

quisiera pedir su ayuda para el siguiente caso.

tengo una tabla que viene con las siguientes columnas Documnet Type, Units, Invoice, ahora bien lo que quiero hacer es restar a Units las unidades cuando en Document Type ZRE y ZVLO tengan el mismo número de Invoice.

Document Type Units Invoice

ZVLO 4 1234

ZRE 2 1234

En este caso restar a 4 de ZVLO 2 de ZRE pero la condición es que Invoice sea el mismo como el ejemplo.

En verdad agradeceré mucho su ayuda ya que no he logrado hacerlo.

Saludos

Re: Restas condicionadas

Kushal_Chawda — Fri, 20 May 2016 15:17:26 GMT

Please share the sample data with expected output

Re: Restas condicionadas

Fri, 20 May 2016 15:20:25 GMT

You expect this response?

Document Type Units Invoice

ZVLO 2 1234

ZRE 2 1234

Re: Restas condicionadas

Anonymous — Fri, 20 May 2016 15:36:16 GMT

The expected response would be like Raúl

Document Type Units Invoice

ZVLO 2 1234

ZRE 2 1234

ZRE even that will not show the final data would only ZVLO .

Thank you very much for your help.