Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
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?

Capture.PNG

Please help!

Thank you.

3 Replies
Master
Master

Re: Finding the number of the dimension

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

Highlighted
Contributor
Contributor

Re: Finding the number of the dimension

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.

Highlighted
Specialist
Specialist

Re: Finding the number of the dimension

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

Thank you!