Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 Num | Date | 2010 | 2011 | 2012 | 2013 | 2014 | 2019 | 2020 | Check12019 | Check12020 |
1099922 | 10/11/2019 | - | - | 10 | 20 | 25 | 33 | 45 | 88 | 45 |
209012910 | 20/12/2019 | 29 | 34 | 45 | 56 | 99 | 164 | 99 | ||
12121234 | 01/10/2020 | |||||||||
654545 | 02/10/2020 | |||||||||
8764545 | 03/10/2020 | |||||||||
|
Can you provide some sample data?
The sample data was already provided in my earlier post.