Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Loop in expression

Hello all,

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

Many Thanks,

Hasvine

4 Replies
marcus_sommer

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

- Marcus

swuehl
MVP
MVP

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

Not applicable
Author

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

marcus_sommer

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#c... from Barry Harmsen.

- Marcus