topic Re: Creating a variable in the script in QlikView

Creating a variable in the script

varunreddy — Fri, 19 Feb 2016 16:51:02 GMT

Hi All,

I have a quick question.I am able to create a variable using variable overview but unable to create it using the script. I know it is silly question. Just wanted to know why I am unable to create in the script.

Calculation Used:

vmaxdate = max(Date)

Thanks in advance!

Best Regards,

Varun Reddy

Re: Creating a variable in the script

Peter_Cammaert — Fri, 19 Feb 2016 19:59:44 GMT

Two reasons

Script aggregation functions can only be used in LOAD statements.
Because you use max() outside of any LOAD statement, it will return the NULL value. Assigning NULL to a variable will effectively delete the variable (if you didn't create it in the Variable Overview first)

If, for instance, field Date is present in a resident table called Calendar, you better use something like this:

MinMaxTable:

LOAD max(Date) AS vMaxDate // Creates a single row with a single value

RESIDENT Calendar;

LET vmaxdate = peek('vMaxDate'); // peek into the table and get that single value

DROP Table MinMaxTable;

Best,

Peter

Re: Creating a variable in the script

varunreddy — Fri, 19 Feb 2016 20:04:54 GMT

Thanks Peter,

Best Regards,

Varun

Re: Creating a variable in the script

swuehl — Fri, 19 Feb 2016 20:06:51 GMT

Just use SET statement:

Set vmaxdate = max(Date);

Set vmaxdate2 = '=max(Date)';

Set vmaxdate3 = =max(Date);