Direct Query Condition Based Filter

[arjunkrishnan]

Dear Qlik Experts,

Direct Query table we able to Condition based filter is Possible or Not,Below following Example I Mentioned,Kindly guide need more helpful for me

I'm trying to Join the Product master and Sales Transaction Table in Direct Query,Here I need to fetch current year of Dimension and Measure

DIRECT QUERY

DIMESION

     A.SALESID as SALESID,

    A.SALESDATE as SALESDATE,

    A.ITEMID as ITEMID,

    B.ITEMGROUPNAME as GROUPNAME,

    B.ITEMCATEGORYNAME as CATEGORY

MEASURE

    A.ITEMSOLDQUANTITY,

    A.LINEAMOUNT

FROM SALESTRANS A,SALESPROUD B WHERE A.ITEMID = B.ITEMID

AND YEAR(SALESDATE) = '2017';