Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
spividori
Specialist
Specialist

Distribution of values

He.

I have the following tables:

Captura.JPG

I need to distribute the values ​​of the Importe_C Importe_D to reach the following result:

Captura1.JPG

Example:

the Nro_D 9 is canceled with Det_id 6144, then Nro_D 10 is canceled with $ 280 of 6144 Det_id, with $ 2000

of 6136 Det_id and $ 300 of 6138 Det_id and so on. Of course very grateful for any help you can give me.

Attached files with data and results.

Regards.

5 Replies
spividori
Specialist
Specialist
Author

I need to do this in the script.

Regards.

spividori
Specialist
Specialist
Author

Any suggestion?
I need help, please!

Regards.

spividori
Specialist
Specialist
Author

Help please, I find no way to do it!

Regards.

spividori
Specialist
Specialist
Author

Excuse my insistence, but I need it.

Regards.

spividori
Specialist
Specialist
Author

Hi.

I resolved this topic. If anyone is interested.Thank you very much.

Regards.