topic Data Load For Loop in QlikView

Data Load For Loop

Thu, 09 Feb 2012 15:08:47 GMT

I'd like to loop through my excel data and and build several items based upon criteria. I've chosen to use a for loop at this time where one of the data elements in my newly created table uses the for counter and also the where clause. ie .

For xi = 1 to 12

month(addmonths(today(),-xi)) as ;

where applicat_report_month << addmonths(today(),-xi);

next xi

it doesn't appear that the where clause is working appropriately.

I'd like to get it so the addmonths is actually calcuated prior to entering the load statment and using a variable in those locations.

thoughts?

thanks

Larry

Data Load For Loop

Jason_Michaelides — Thu, 09 Feb 2012 15:17:33 GMT

Is that because you have << instead of < ?

Re: Data Load For Loop

Thu, 09 Feb 2012 15:20:42 GMT

Hi Larry,

Is this WHERE statement your real statement? Are you using literally where applicat_report_month << addmonths(today(),-xi); ?

If so, try it like this: where applicat_report_month < addmonths(today(),-xi);

Regards,

Marina

Data Load For Loop

Thu, 09 Feb 2012 19:08:14 GMT

I have tried bioth ways with an additional item being that as soon as i hit the less than sign <, the tool prompts for one of three choice, (<<, <=, or <>).

The data still doesnt represent the expectation in either case.