Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following pivot structure in Qlik, These are the installments that has been paid.. I looking for a way to sum this up at row level..in a new field ( Not the Totals)
For Ex: if the current month is 2019 May -- Then i should get a sum of 9874 for the reference KBC093223232
If the Current month is august then it should be 9874 +9874
Thanks to advise here..
Reference | Date | Dates | 01/01/2019 | 01/02/2019 | 01/03/2019 | 01/04/2019 | 01/05/2019 | 01/06/2019 | 01/07/2019 | 01/08/2019 | 01/09/2019 | 01/10/2019 | 01/11/2019 | 01/12/2019 | 01/01/2020 |
KBC093223232 | 30/01/2019 | 9,874 | - | - | - | - | - | 9,874 | - | - | - | - | - | 0 | |
- | 0 | - | - | - | - | - | 0 | - | - | - | - | - | |||
- | - | 0 | - | - | - | - | - | 0 | - | - | - | - | |||
- | - | - | 0 | - | - | - | - | - | 0 | - | - | - | |||
- | - | - | - | 0 | - | - | - | - | - | 0 | - | - | |||
- | - | - | - | - | 0 | - | - | - | - | - | 0 | - | |||
KBC9232323w | 17/03/2019 | 0 | - | - | - | - | - | - | - | - | - | - | - | - | |
- | 0 | - | - | - | - | - | - | - | - | - | - | - | |||
- | - | 5,392 | - | - | - | 5,392 | - | - | - | 5,392 | - | - | |||
- | - | - | 0 | - | - | - | 0 | - | - | - | 0 | - | |||
- | - | - | - | 0 | - | - | - | 0 | - | - | - | 0 | |||
- | - | - | - | - | 0 | - | - | - | 0 | - | - | - |
I think you will need to explain your data once more, because it is not obvious how you get 9874 for May and 19 748 for August.
Anyway, I would assume you will need to use crosstable() in the script in order to get the data structured in a way that supports the calculations you need to do in the application.