Fib

[aka_qlik]

Hi all,

Any suggestions? 

Thanks for your help and ideas! 

[marcus_sommer · Accepted solution]

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

[tresesco · Accepted solution]

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