Dynamic Calendar based off List Box

[#1]

I am fairly new to QlikView and I think I am diving into advanced functions a little quick.

First Table:

SCRA_DateField_Chooser:

Load * INLINE [

     TEST_ID, Date_Short, Date_Full

     1, ASSIST_EFF_DATE, Assist Effective Date

     1, CREATE_DATE, Create Date

     1, TRAN_DATE, Transaction Date

];

Second table:

TestLoan:

Load Distinct 1 as TEST_ID,

     ACCOUNT_NBR From $(qvdPath)VW_A004.qvd(qvd);

Third Table:

SCRA_04_FeesAssessed:

LOAD ACCOUNT_NBR

     SCRA_04_FeesAssessed.ASSIST_EFF_DATE,

     SCRA_04_FeesAssessed.TRAN_DATE,

     SCRA_04_FeesAsssessd.CREATE_DATE

From

$(qvdPath)VW_A004.qvd

(qvd);

Table Joins:

TestLoan.TEST_ID to SCRA_DateField_Chooser.TEST_ID

TestLoan.ACCOUNT_NBR = SCRA_04_FeesAssessed.ACCOUNT_NBR

I then have it set up when i click on Test_ID = 1 in the tablebox from the Main Sheet, it will Launch SH02 and automatically filter TEST_ID = 1 using a Trigger on TEST_ID where I set Variables.

Here is the question:  I have Created 1st Listbox that has the Date_Full names in it so the person can select which Date they want to filter by.  I was then trying to create a Trigger on Date_Full that will Set Variable vSelectedDate = IF(TEST_ID = 1,'SCRA_04_FeesAssessed.' & Date_SHORT,0)  which seems to work and sets my Variable to SCRA_04_FeesAssessed.CREATE_DATE.

I was then creating a second listbox that would have in the General tab/Field Expression = vSelectedDate to pull the dates from this field, but I am having no luck Error = (unavailable)[SCRA_04_FeesAssessed.CREATE_DATE].  I was essentially trying to make this into a Calendar function and create Month(vSelectedDate) or Year(vSelectedDate), so the user can select which date they want and the time frame they need.

I know I could build either a container or build listboxes for month/year in them for each of the dates, but I would think that isn't efficient, especially since I have to build 8 more identical sheets.

Thanks,

[#2]

Thanks Michael for you reply.  I tried this with the TransDate first to make sure it works and it did. 

Thanks very much this is exactly what I was trying to do.