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

I have the below structure pivot in qlik... I am looking for a way to calculate Check12019 = Sum of 2010 to 2019

Check2 = 2020 as it is. Thanks to suggest

 

Account NumDate2010201120122013201420192020Check12019Check12020
109992210/11/2019--10202533458845
20901291020/12/2019  293445569916499
1212123401/10/2020         
65454502/10/2020         
876454503/10/2020         
          

 

 

Labels (1)
2 Replies
Highlighted
MVP
MVP

Can you provide some sample data?

Highlighted
Creator II
Creator II

The sample data was already provided in my earlier post.