Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

akumar271194
New Contributor

how to calculate cagr where difference in years is provided by user via variable?

i have a variable named diffyear which would be given by user

The beginning value should be calculated using diffyear

cagr=((end value/beginning value)^(1/diffyear))-1

i only want to find cagr for three years.I have used below but it gives last value null

Tags (2)
2 Replies

Re: how to calculate cagr where difference in years is provided by user via variable?

Is below giving null because you have only selected 3 years? If that is true, then all you need to do is to ignore selection in year field within the expression you use inside below....

akumar271194
New Contributor

Re: how to calculate cagr where difference  in years is provided by user via variable?

thanks for the solution Sunny Talwar

Community Browser