Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

spividori
Valued Contributor

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
Valued Contributor

Distribution of values

I need to do this in the script.

Regards.

spividori
Valued Contributor

Distribution of values

Any suggestion?
I need help, please!

Regards.

spividori
Valued Contributor

Distribution of values

Help please, I find no way to do it!

Regards.

spividori
Valued Contributor

Distribution of values

Excuse my insistence, but I need it.

Regards.

spividori
Valued Contributor

Distribution of values

Hi.

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

Regards.

Community Browser