Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Restas condicionadas

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

3 Replies
Kushal_Chawda

Please share the sample data with expected output

Not applicable
Author

You expect this response?

Document Type     Units     Invoice

ZVLO                    2          1234

ZRE                      2          1234

Anonymous
Not applicable
Author

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.