I have the table below in Qlikview.
The cells highlighted in yellow shows the variance between the 3 years and needs to be dynamic such that
1. If it is under Jul 2015 - Jun 2016, the cell in yellow under Jul 2015 - Jun 2016 should display AY14 VS AY15
2. If it is under Jul 2016 - Jun 2017, the cell in yellow under Jul 2016 - Jun 2017 should display AY15 VS AY16
3. If it is under Jul 2017 - Jun 2018, the cell in yellow under Jul 2017 - Jun 2018 should display AY16 VS AY17
How do I identify the number of the dimension?
What do you mean by number of dimensions? Are you asking for number of Type?
For example, if the yellow cell belongs to column 1, then display AY14 VS AY15.
If column 2, display AY15 VS AY16, if column 3 display AY16 VS AY17. I need to identify which dimension does the cell belong to.
Please share data or sample application. Try once with straight table.