Discussion Board for collaboration on QlikView Scripting.
I would like to make a #Include script that returns these variabls:
Right now I have had to define these in the Variable Overview so I would have to define these on every document that uses these variables. Is there a way to make this a script that loads my table (see attached QlikView and XLS) and then creates these variables and then drops the table?
Thank you very much!
Solved! Go to Solution.
Quartername is a inbuilt QlikView function. If you mandatorily have to have Q1 then you have to use mapping or you have to hardcode string.
I tried that but get line errors on all of the variables. Not really sure what I am doing wrong. It appears to have a problem with Peek and Concat both in the script... so how do I get the value from the table loaded into the variable?
I think you need to define the variables to have the text used. For example,
vCurQtr = 'Text(Year(Today())+Max(CurYr))' & Chr(38) & '-' & Chr(38) & 'Concat(currQtr)'
My goal is to set the variables, not leave them dynamic... so were it to run today, it would say:
There are different ways of doing it. See if this helps you
let vCurrQtr=QuarterName (today());
let vCurQOQYOY_Qtr =QuarterName (today()) &'|'&QuarterName(today()-90);