Complex Mathematical Functions

Mon, 10 Oct 2011 10:17:20 GMT

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

Re: Complex Mathematical Functions

swuehl — Mon, 10 Oct 2011 11:49:15 GMT

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

topic Complex Mathematical Functions in QlikView

Complex Mathematical Functions

Re: Complex Mathematical Functions