17 Replies Latest reply: Dec 8, 2016 9:56 AM by Dean Vincent RSS

    Collate two fields from Access Database to create daily view/record

    Dean Vincent


      Please could i ask for your help...

      I update my Access Database on a daily basis, so there are multiple duplicated entries (OLE DB)

      The measure i am using is the "Project" field (these are our Customers) but the issue i am having when i am adding the "Created" or "Import Date" field, i am receiving a count of all records, when i only would like the overview from yesterday/today entries.

      I have tried multiple FX's but nothing seems to work.


      Example Project (Customer):




      Examples Created/Import date (Day):




      = today()-7 and DateField < today(),


      Please could I ask for your help.

      P.S. I am using Qlik Sense Desktop