Skip to main content
Announcements
Meet our latest featured member Bruno! Drop a like and comment. READ ON
cancel
Showing results for
Search instead for
Did you mean:
Contributor

## Finding the number of the dimension

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.

3 Replies
Master

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

Contributor
Author

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.

Specialist

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

Thank you!

Community Browser