Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

GAGR projections calculation - Table Pivot

Hello qlik experts,

I have a question regarding a year projection metric.

In the DATA.xlxs file I have information on the quantities from 2014 to 2018. I need your support with generating the new data from 2019 to 2013 for each country. The "calculated" tab shows the calculation of% and how the following calculations are performed. Please support her with this need. 

 

The image shows the example.

Labels (2)
1 Reply
Highlighted
Creator II
Creator II

Gráfico.jpg