Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

arjunkrishnan
Contributor

Direct Query Condition Based Filter

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';

Community Browser