Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

summing row

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..

KBC09322323230/01/2019 9,874-----9,874-----0
KBC9232323w17/03/2019 0------------





Labels (1)
1 Reply

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.

Plees ekskuse my Swenglish and or Norweglish spelling misstakes