Hi Expertise
I am new to Qlik Sense. Currently I am working on Set Analysis part but not able to understand how will it work. Could you please assist me to get basic understandingof it.
I have sample data where data is divided Qtr wise as below. I have requirement like to show sales year wise as shown in last column.
Could you please assist me which function work here ?
Year Qtr Sales Year Wise Sales
| 2004 | Q1 | 100 | 1000 |
| 2004 | Q2 | 200 | 1000 |
| 2004 | Q3 | 300 | 1000 |
| 2004 | Q4 | 400 | 1000 |
| 2005 | Q1 | 500 | 2600 |
| 2005 | Q2 | 600 | 2600 |
| 2005 | Q3 | 700 | 2600 |
| 2005 | Q4 | 800 | 2600 |
