EXPRESSION ISSUE

[#1]

I have the below query I am trying to accomplish in my dashboard. The issue is that I am trying to make the 2 Dates Dynamic (Start and End)  and Qlikview is not giving me the right answer.  What do I need to do to accomplish this in Qlikview. PLS HELP

I have tried  the Set Analysis like this . as_of is ('YYYYMM') Format. I have created the Year and Months from both Dates

Count({<AS_OF_BEGIN={Max(END_YEAR))}>} distinct Claim_No)

-

Count({<AS_OF_BEGIN={Max(END_YEAR)-1)}>} distinct Claim_No)

select

a1.claim_no  , b1.claim_no,

b1.claim_type_code as old_claim_type_code,

a1.claim_type_code as  current_claim_type_code,

a1.as_of  as AS_OF_END,

b1.as_of  as AS_OF_BEGIN

from

(select a.as_of, a.claim_no, a.claim_type_code

from odwr_claimsnapshot a

WHERE A.as_of  ='201506') a1

left outer join 

(select b.as_of, b.claim_no, b.claim_type_code

from odwr_claimsnapshot b

WHERE B.as_of  ='201412') b1

on a1.claim_no = b1.claim_no

where  (a1.claim_type_code <> b1.claim_type_code or b1.claim_no is null)