What do you mean when you say "I can not get my variable to show up in Qlik Sense"? Don't you see the variable at all? It is a text variable and it would be easy to see if it exists at all and what the content is? Or doesn't it calculate to anything?
The way you have put the expression in the vEffectiveDate you have it as a text string - and it will not calculate anything until you force it to calculate in the QS App in an expression in a chart. That is as it should be.
However to get it to calculate you might have to use the = sign like this =$(vEffectiveDate)).
You expression could be this:
If Effective_Date__c is a real date, if not make sure that it is when you bring it in in a load statement:
Date(Date#(Effective_Date__c,'MM/DD/YYYY')) AS Effective_Date__c,
You can't make this expression in your variable to a dimension as you have specified it since you are using an aggregation function ... Max().
Do you have a screenshot or more to share? In the chart/table that you use it as a dimension and measure what kind of table is it and does the table have other dimensions?
Do you get any kind of values in the three places? A 0 or a dash or blank?
Yea, I know it won't work as a dimension, I was just trying everything to see what it would do.
Script is this
Set vEffectiveDate = 'Date#(Date(Floor([EffectiveDateVariable])))';
I have one other value in the table and in the data model both fields are in the same data model table, so there should be a one to one relationship.