topic Re: Position and Movements in QlikView

Position and Movements

avicentbarcelo — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I need help solving this little problem.

On the one hand, we have a table with the final position or balance of several accounting counters to a date.

On the other hand, we have a table with the movements produced in each date for each account

The result that I want to obtain is a table with the starting position, the sum of movements and the final position of each account at each date

This would be the result

I attach an excel file with the above data and the expected result

Thanks in advance for your invaluable help

ramasaisaksoft — Wed, 22 Feb 2017 06:17:37 GMT

i don't have licensed version of Qlikview Could you please check your self the below attachment in that thread.

avicentbarcelo — Wed, 22 Feb 2017 06:21:44 GMT

No, the problem isn't colour, the problem is to obtain Position Final and Inic¡tial for each Count