topic how can I make a ciclo in an expression in QlikView

how can I make a ciclo in an expression

Thu, 11 Jul 2013 20:44:29 GMT

I mean, I need a ciclo in an expression because
the value of this field that I need to calculate dynamically.

for example the cost promedio which depends to de quantity in the wharehouse and the quantity of buy.

somebody know any way to do this.

best regards.

swuehl — Thu, 11 Jul 2013 21:20:03 GMT

Not sure if I understand, you mean a loop in a (chart) expression?

Can you describe a bit closer what you want to achieve, maybe with some sample lines of data and your expected outcome?

Fri, 12 Jul 2013 14:50:18 GMT

swehl thanks for the answer,
yes I need a loop if is possible like 'while' or something like that,
and nested
some like this

while (var1 < var2)
begin
etc.
etc.
if(var1<>0)
etc.
while(var3<> var1)
begin

end

thanks a lot.

swuehl — Fri, 12 Jul 2013 15:55:48 GMT

And you want to do this in a chart / frontend expression?

In general, that's not the way QV works, but maybe there is an approach using aggregation functions. Could you describe your business requirement?

And if possible, try to create a small sample QV application and attach your expected expression outcome.