Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Any suggestions?
Thanks for your help and ideas!
IMO there no such function available in Qlik and I think it could be come quite difficult to calculate it within the UI. But you could load (externally or just creating them) these information as table and then pick/calculate your wanted values from there maybe with some set analysis, like (related to the below load):
concat({< N = {"<$(=max(N))"}>} F, ', ')
load *, F / previous(F) as Q;
load *, rangesum(if(N < 2, N, 0), peek('F', -1), peek('F', -2)) as F;
load recno()-1 as N autogenerate 50;
- Marcus
One possible UI solution could be like:
Dim (Hide it in the presentation tab) :
=ValueLoop(1,nTHVar)
Exp :
=if(RowNo()=1,0,if(RowNo()=2,1,
RangeSum(ValueLoop(1,nTHVar-2),Above(Fibo,1,2))
))
IMO there no such function available in Qlik and I think it could be come quite difficult to calculate it within the UI. But you could load (externally or just creating them) these information as table and then pick/calculate your wanted values from there maybe with some set analysis, like (related to the below load):
concat({< N = {"<$(=max(N))"}>} F, ', ')
load *, F / previous(F) as Q;
load *, rangesum(if(N < 2, N, 0), peek('F', -1), peek('F', -2)) as F;
load recno()-1 as N autogenerate 50;
- Marcus
One possible UI solution could be like:
Dim (Hide it in the presentation tab) :
=ValueLoop(1,nTHVar)
Exp :
=if(RowNo()=1,0,if(RowNo()=2,1,
RangeSum(ValueLoop(1,nTHVar-2),Above(Fibo,1,2))
))