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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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