EXPRESSION ISSUE

Mon, 15 Jun 2015 15:02:21 GMT

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)

topic EXPRESSION ISSUE in QlikView

EXPRESSION ISSUE