Discussion board where members can get started with Qlik Sense.
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..
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.