topic Re: How to assign variables to for loop,in which values are pulled from Field in QlikView

How to assign variables to for loop,in which values are pulled from Field

sridhar423 — Thu, 22 Jan 2015 10:29:18 GMT

Hi All,

I'm unable to assign max and min values to the variables.I'm getting error ,here is my code is there any fault,can any one help me out from this.

Sheet1:

LOAD

BusinessDate,

Year(BusinessDate) as Year,

BusinessID,

CustomerName,

Location,

ShipperID

FROM

(biff, embedded labels, table is Sheet1$);

Let vMin=Min(Year);

Let vMax=Max(Year);

For i=$(vMin) to $(vMax);

NoConcatenate

LOAD *

Resident Sheet1

Where Year=$(i);

STORE T into $(i).qvd;

Drop Table T;

NEXT i;

vikasmahajan — Thu, 22 Jan 2015 10:39:56 GMT

Brefore loading excel sheet create another load

MinMax:

Load min(year) as MinYr,

Max(year) as Maxyr

FROM

(biff, embedded labels, table is Sheet1$);

store this into varibles

then use in script

HTH

Vikas

marcus_sommer — Thu, 22 Jan 2015 11:16:10 GMT

You could use peek() or fieldvalue() to grab the values from a table how suggested from Vikas Mahajan - see here for examples: http://community.qlik.com/blogs/qlikviewdesignblog/2013/04/08/peek-vs-previous-when-to-use-each.

- Marcus