2 Replies Latest reply: Oct 26, 2017 1:09 PM by Wallo Atkinson RSS

    Filtering on multiple dates

    Ozgur Cirak

      Hello

       

      I need to develop a CRM Analysis Tool in QLIK Sense. I have two tables. One is master calendar and one have details about all opportunities.

       

      In my opportunities tables, i have field names :

      OpportunityName

      Status

      Percentage

      SalesRep

      Product

      Customer

      Target Date

      Entry Date

       

      Sales Director needs to filter opportunities by week(this information is on master calendar). When i try to filter, it filters on target date, not on entry date.

       

      How do i need to make relations so i can simultaneously filter on both target and entry date? stalwar1