Discussion board where members can get started with Qlik Sense.
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
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....
thanks for the solution Sunny Talwar