Finding the number of the dimension

[suthashiniv]

Hi,

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?

Please help!

Thank you.

[shiveshsingh]

What do you mean by number of dimensions? Are you asking for number of Type?

[suthashiniv]

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.

[isingh30]

Please share data or sample application. Try once with straight table.

Thank you!