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).