Hello All,
I'm currently trying to get a document into SVN via QlikView's integrated SVN support and through my research, I found that variables entered into the Variables tab of the Document Properties Dialog will not persist in source control so my first step was to move all of my variables to my script (best practice anyway) and reload to make sure everything came through as expected.
Things looked great until I got to a variable in which set analysis and dollar sign expansion were used. Here's what I I'm dealing with:
- The variable value from the dialog as it was before moving it to the script:
=Sum({<EnrollmentDate_SD1 = {">=$(#vPlanYear_CurrentStart)"}, ClmPdDt_MonthYear=, IncurFromDt_MonthYear=, EnrollmentStatus={'Employee'} >}[Medically Eligible Month]) - The script I wrote to replace what had been entered into the dialog previously:
SET vPlanYear_Current_Employee_Months = "=Sum({<EnrollmentDate_SD1 = {">=$(#vPlanYear_CurrentStart)"}, ClmPdDt_MonthYear=, IncurFromDt_MonthYear=, EnrollmentStatus={'Employee'}>}[Medically Eligible Month])"; - The variable value from the dialog after the reload:
"=Sum({<EnrollmentDate_SD1 = {">=0"}, ClmPdDt_MonthYear=, IncurFromDt_MonthYear=, EnrollmentStatus={'Employee'}>}[Medically Eligible Month])"
So it looks to me like instead of pulling my variable value through like it did with other variables I have using functions, it did the dollar sign expansion and nothing else.
Any ideas on what I need to do in the script to get my variable value to end up like it is in (1) above? Any input would be greatly appreciated because I need to get this project into source control but cannot do so if I'm going to lose these variable values.
Thanks!
