topic Loop in expression in QlikView

Loop in expression

Thu, 13 Oct 2016 08:57:34 GMT

Hello all,

Is it possible to create a loop in the expression tab?

Many Thanks,

Hasvine

Re: Loop in expression

marcus_sommer — Thu, 13 Oct 2016 09:03:04 GMT

Not really ... what do you want to do?

- Marcus

Re: Loop in expression

swuehl — Thu, 13 Oct 2016 09:16:04 GMT

An expression uses aggregation functions to aggregate a record set, so it's kind of a loop, iterating over each record.

But you probably are looking for something else.

There are no functions / statements to create a loop like you can do in the script, but maybe you can hack QV using ValueLoop() inside an aggregation function:

Re: Complex Mathematical Functions

Re: Loop in expression

Thu, 13 Oct 2016 09:24:59 GMT

Hello Guys,

Actually I have posted something last time and I did not get any response on the topic:

Erlang C

I need to calculate the Erlang C as per the link below:

6. Calculate the Erlang-C formula

I am stuck on this 1.

Any idea?

Kind Regards,

Hasvine

Re: Loop in expression

marcus_sommer — Thu, 13 Oct 2016 09:39:40 GMT

Maybe you could transfer your loop to a macro-function like described here: https://community.qlik.com/blogs/qlikviewdesignblog/2014/10/03/teaching-the-load-script-new-tricks#comment-21495 from Barry Harmsen.

- Marcus