Hi, I have a data set which looks a little like the table below. This is completely hypothetical but the structure of the data is pretty much the same.
Touch Month | Campaign | Cell | Income Total | Flows Total | HH Total | Type |
---|
01/01/2014 | Camp1 | Cell 1 | 100 | 200 | 20 | Type 1 |
---|
01/01/2015 | Camp1 | Cell 1 | 220 | 340 | 40 | Type 1 |
---|
01/01/2015 | Camp1 | Cell 2 | 120 | 210 | 20 | Type 1 |
---|
01/02/2015 | Camp2 | Cell 1 | 210 | 340 | 50 | Type 3 |
---|
01/01/2016 | Camp2 | Cell 1 | 270 | 420 | 70 | Type 3 |
---|
01/05/2016 | Camp7 | Cell3 | 750 | 1250 | 75 | Type 2 |
---|
Now, what I want to do is to find out the year on year change (%) based on the selection of the month. For instance, if I have no selection for campaign or cell and I select Income total as my parameter of interest with selection of touch months 01/01/2016,01/02/2016 and 01/03/2016, I get the Year on Year change W.R.T 2015 for these months and if say I select just may of 2016 as my touch month the Y-o-Y change should reflect just between may 2016 and may 2015.
Is there a way to do it?
Thank you.
P.S: I'm just a few weeks old in terms of the qlik environment.
Edit 1: I'm trying to figure the year on year change for Average Income (i.e, Income Total/HH Total).