topic Set Analysis Query in QlikView

Set Analysis Query

Thu, 13 Oct 2011 18:36:05 GMT

Hi All,

Please Suggest how to write this query in Set Analysis.

SET TempSum=0

Set CountRow=0

while(CountRow<162522)

{

If(NoOfPallets<>0)

TempSum= TempSum+Pallet

CountRow++;

}

Thanks,

Sandeepa

Re: Set Analysis Query

Fri, 14 Oct 2011 06:30:56 GMT

anyone??

Re: Set Analysis Query

Miguel_Angel_Baeyens — Fri, 14 Oct 2011 07:52:42 GMT

Hi,

As I asked you in a following post, where do you want to use that expression? If it's in an expression, you simply cannot do it. You cannot use loops in an expression. If CountRow is a dimension, then the expression should look like

Sum({< CountRow = {'<162522'}, NoOfPallets = {0} >} Pallet)

But please specify your requirements, actual input and expected output in your load script.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica