What to use instead of loop in Qlikview??

[Anonymous]

Hi

I have a condition where i have to take selected text from the textbox.

for eg textbox contains the following text:

following files have error

App_ABC:  following error found

error: error_ABC

Resolution

App_mmm:  following error found

error: error_mmm

Resolution

App_XYZ:  following error found

error: error_XYZ

Resolution

End

Now I want to only the Error part in text box. For that i am using Textbetween() which is working perfectly if error is found in only one app. But for multiple Apps it is showing error for first app.

I wanted to use loop, but came to know that cannot use Loop in expressions. So what can we use instead of loop?? If not how should we implement in a macro.

[swuehl]

A loop will be automatically performed if you use an aggregation on a field, but as I understand, you don't have a field, but.. what? a variable?

Could you upload a small sample file that demonstrates your current setting and what you want to do with the error descriptions?

[Anonymous]

Hi Swuehi

Thanks for the reply

Its a variable actually.

Here I am saving outlook mail into a variable through macro, then calling it in a textbox.

So, it is showing the way I have given in the eg. above.

(Actually I am not allowed to upload anything from company's dekstop)

Thanks

Bhumika