Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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..

ReferenceDateDates01/01/201901/02/201901/03/201901/04/201901/05/201901/06/201901/07/201901/08/201901/09/201901/10/201901/11/201901/12/201901/01/2020
KBC09322323230/01/2019 9,874-----9,874-----0
 -0-----0-----
 --0-----0----
 ---0-----0---
 ----0-----0--
 -----0-----0-
KBC9232323w17/03/2019 0------------
 -0-----------
 --5,392---5,392---5,392--
 ---0---0---0-
 ----0---0---0
 -----0---0---
 
 

 

 

 

 

Labels (1)
1 Reply
Highlighted
Partner
Partner

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