topic Re: Fibonacci Sequence in QlikView

Fib

aka_qlik — Thu, 10 Sep 2020 06:17:40 GMT

Hi all,

Any suggestions?

Thanks for your help and ideas!

Re: Fibonacci Sequence

marcus_sommer — Wed, 09 Sep 2020 07:23:56 GMT

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

Re: Fibonacci Sequence

tresB — Wed, 09 Sep 2020 12:44:01 GMT

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))
))