Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am getting this error I've never seen before. Could someone please explain to me what this error means and what I can do to fix this?
Any help is appreciated. Thank you.
Did it work when you changed
let vEvalYr = mid($(vEvalYrQuarter),3,2);
to
let vEvalYr = mid('$(vEvalYrQuarter)',3,2);
?
Share the code please.
It seems you are having a variable as the first parameter and the variable is null.
Make sure the variable has a value and enclose it with single quotation like this '$(vString)'
Here is the code:
let vEvalYrQuarter = Mid(DocumentPath(),117,6); //ex 201912
let vEvalYr = mid($(vEvalYrQuarter),3,2);
let vEvalQuarter = right($(vEvalYrQuarter),2);
Let vLargeLossCutOff=$(vEvalYrQuarter)-500; //Should be 5 Years Prior to eval quarter
let
vAutoLossData='\\Profitability\ActuarialShare\Indications\CW\Auto\$(vEvalYrQuarter)\A$(vEvalYr)$(vEvalQuarter) 16 Loss Datasets.xlsm';
let vAutoTrendData='\\Profitability\ActuarialShare\Indications\CW\Auto\$(vEvalYrQuarter)\Trends - Qlikview\Auto_Trend_Data.xlsx';
Did it work when you changed
let vEvalYr = mid($(vEvalYrQuarter),3,2);
to
let vEvalYr = mid('$(vEvalYrQuarter)',3,2);
?
Yes, this worked!
Thank you Hesham!