topic Load a field as single value for variable, how to hard code it? in QlikView

Load a field as single value for variable, how to hard code it?

Tue, 05 Jun 2012 15:12:21 GMT

Hi community,

I load a field as a single value in the script and and use it as the value for a variable to use in set analysis. The field only has one value but since I load other tables, sometimes the field value is not selected and the variable has no value. Is there anyway to hard code the value in the field so that it is what it is regardless of selection?

Load a field as single value for variable, how to hard code it?

Tue, 05 Jun 2012 15:14:19 GMT

Yes I figured it out. You have to use set analysis in the variable definition like:

=only({1}[Current Fiscal Week])

Load a field as single value for variable, how to hard code it?

Tue, 05 Jun 2012 15:31:15 GMT

I did something like that once, I read a date from a file and save it into variables and then I could use it on the final reports, what I did was:

//source

LastDateFile:

LOAD Date as LastDate

FROM

File.txt

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

//Variables:

let vDateExt = date(peek('LastDate',0,'LastDateFile'));

let vDay = Day(vDateExt);

let vMonth = Month(vDateExt);

let vYear = Year(vDateExt);

Regards!