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