Set analysis, less than or equal to, variable. Not calculating correctly.
I have been given a QlikView model where there was a date input (vLoanBalanceDate) and this date was used in the following first measure below.
I am now on QlikSense recreating their model and want to calculate the same measure, using variables I have created, instead of the vLoanBalanceDate input.
I now have variables that contain the maximum dates I need to use in my set analysis. Could you please assist me with the set analysis script. I will attach a photo of the dates reflecting correctly in the new variables and also the statement I thought was right?
The original measure on the old QlikView model I was given:
My new measure not working along with the new variables I need to use: (One to calculate the cumulative sum up to the max date on the selection and the other I want to show what the sum of tx's was a year ago)