Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am wondering if anyone can help me as i am very confused!
I have recently received a large number of very complex mathematical equations that need to be loaded to charts and tables within Qlikview. An example of which is shown below:
s k
CL <= ∑ (nλR) exp(-nλR)
k=0 k!
where n, λ, R, CL and S are defined.
I have been able to locate exponential functions within Qlikview, i am just curious as to whether it would be able to cope with complex mathematical equations such as the one shown above and whether you can do a sum function between two values such as k=0 and s as taken from the example above.
Any help would be greatly appreciated!!
Regards,
Steven Prentice
Steven,
your function could look like this:
=sum(pow(nlR,ValueLoop(0,s,1))*exp(-nlR)/fact(ValueLoop(0,s,1)))
where the Valueloop will generate your sum index counter k, running from 0 to s in increment 1 step. I also defined Variables s and combined nlR (for latter you could of course use separate variables and multiply them.
fact will calculate the factorial of k.
Please look at attached sample file also.
You could of course put the outcome of above in a if function to compare to CL.
Hope this helps,
Stefan