Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
4 Replies
marcus_sommer
MVP
MVP

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

- Marcus

swuehl
Champion III
Champion III

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

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