topic Re: Simple variable question [Load scripts] in QlikView

Simple variable question [Load scripts]

Thu, 10 Jan 2013 14:24:43 GMT

Afternoon All,

Simple question, hopefully my code will speak a thousand words here.

I am trying to do BELOW In my load script.

let minSellingGross = MIN([Selling Gross]) ;

Does anyone know why this isn't assigning the variable? I assume because the data hasn't been actually loaded it can't do it yet.

What is best practice whilst trying to hardcode a variable?

Many thanks,

James.

Re: Simple variable question [Load scripts]

giakoum — Thu, 10 Jan 2013 14:28:06 GMT

if Selling Gross is a field previously loaded in the script, you should use fieldvalue function to assign its min value to a variable

Re: Simple variable question [Load scripts]

Thu, 10 Jan 2013 15:12:04 GMT

Seems the way I got it working was:

Testing:
load
MIN([Selling Gross]) AS MinSellingGross,
MAX([Selling Gross]) AS MaxSellingGross
Resident Main;

let vMinSellingGross = Peek('MinSellingGross');
let vMaxSellingGross = Peek('MaxSellingGross');