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

      Hi,

      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):

       

      Count({$<Project={"xxx","xxx","xxx"}>}Project)

       

      Examples Created/Import date (Day):

       

      ={">=$(=date(today()-1,'DD/MM/YY'))"}>}

       

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

       

      Please could I ask for your help.


      P.S. I am using Qlik Sense Desktop