topic set a variable in Script in QlikView

set a variable in Script

Anonymous — Thu, 29 Mar 2012 19:22:23 GMT

Hi all,

Please help me with the instructionto set a variable at a script time to get (from SQL table) a variable witha max number from a field and another variable with the minimum valuefrom a field.

set a variable in Script

sebastiandperei — Thu, 29 Mar 2012 20:05:37 GMT

Hi, in first place, you must load the table from SQL:

SQLTable:

SQL Select Distinct Field From Table;

Aux:

Load

Max(Field) as Max,

Min(Field) as Min

Resident SQLTable;

Let Var=Peek('Field');

Drop Table Aux;

Try and tell me how it works!!

set a variable in Script

Anonymous — Thu, 29 Mar 2012 20:17:05 GMT

Thanks Sebastian. worked well.