Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
avicentbarcelo
Contributor II
Contributor II

Position and Movements

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.

   Imagen 1.png

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

imagen 2.png

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

imagen 3.png

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

Thanks in advance for your invaluable help

2 Replies
ramasaisaksoft

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

Straight Table Background Row Colors | Qlik Community

avicentbarcelo
Contributor II
Contributor II
Author

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