topic Re: Balance and Movements in QlikView

Balance and Movements

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

Hello,

I' sorry because my english isn't good.

Forgive me if what I ask is simple to solve, but I'm new and I do not have much practice with QV.

I have a table with the following information:

- Account

- Closing Date

- Balance

With one record for each account and not always all accounts have the same closing date.

and another table with those produced movements, with the following data:

- Account

- Date Movement

- Amount

Given that on a date (Date Movement) may have several records movements and that not all movements have time, I would get a table with the following data.

- Account

- Date

- Balance date (sum of all movements that date)

- Balance on that date

Keep in mind that the Closing Date is greater than or equal to all movement dates from that account.

I would appreciate your help very much.

Regards,

Ana

Re: Balance and Movements

varshavig12 — Mon, 07 Nov 2016 03:45:38 GMT

Can you provide us with some sample data and the expected output ?

Re: Balance and Movements

ElizaF — Mon, 07 Nov 2016 11:23:29 GMT

Hello,

You can use the "As Of Table" concept. See below the link:

The As-Of Table

Re: Balance and Movements

Anil_Babu_Samineni — Mon, 07 Nov 2016 15:59:17 GMT

I Recommend you to don't create two threads for single Issue

Please get back my response. So that, We can look in deep.

Balance and Movements