However, I have run into an issue where I have a need for a variable to be loaded based on the value of another variable. Let me explain what I mean.
Lets assume I have these two variables:
vMedClaim = 1;
vDrillNo = IF($(vMedClaim) = 1, '<250',250);
What I want to occur, during the script refresh, is for vDrillNo to either be '<250' or 250 as determined by the vMedClaim variable. However when I follow the method outlined in Barry's blog, the full expression is stored as the value of vDrillNo even though I am using the LET command.
Note - In these files the variables are vMedClaims and vDrilldownSvcCat (instead of vDrillNo).
My goal is for vDrilldownSvcCat to be loaded into qlikview having the expression evaluated (so it returns either the <250 or 250) as I am trying to use $(vDrilldownSvcCat) in the following set analysis: