Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
avicentbarcelo
New 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
Valued Contributor III

Re: Position and Movements

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
New Contributor II

Re: Position and Movements

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