0 Replies Latest reply: Dec 8, 2017 1:04 AM by NagaArjun Krishnamoorthy RSS

    Direct Query Condition Based Filter

    NagaArjun Krishnamoorthy

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