Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I am sorry but could you please show me where to place the two lines...
I have attached the script
Many thank in advance
Morning Gysbert,
sorry to bother you but please could i ask if you could have a formula (and double check the script for me) as i am still not getting yesterday import?
Add the two lines to the load that loads the data from your source table. The table you named Orders. In the AppsPackBAU section.
Thank You so much for all your help.
i know have a working expression
"count({<Project={"UK Channel 4","UK Direct Line Group","UK Eversheds","UK LBiE","UK Network Rail","UK NFU Mutual","UK Post Office","UK Royal Mail Group","UK Schroders","UK Serco","UK UNISON","UK Visa","UK Yorkshire BS"}>*(<DaysAgoImported={1}>)}[Import Date])"
i am almost there now...
Please could i ask for your help? Please could you tell me what is wrong with this expression?
"Count({<Created_Year={'2016'}>*(DaysAgoCreated={1}>)}Created_Year)"
Count({<Created_Year={'2016'} >*( DaysAgoCreated={1}>)}Created_Year)
It's missing a < character. But since you're only using DaysAgoCreated you can simplify the expression to
Count({<Created_Year={2016},DaysAgoCreated={1}>}Created_Year)
Thank you, i have tried the FX but it isnt work?
Count({<Created_Year={2016},DaysAgoCreated={1}>}Created_Year)
i am trying to us this on a KPI chart
is there a different way that the formula can be presented? (created year count of all entries)
No idea. I can't mind read your app from here.
Hi Gysbert,
I honestly have to say thank you for all your help and guidance...
it really has help (Sorry im so green)
Please could i ask if you could help with this topic?
"OLE BD - ACCESS BD - Formula to only count today's entries"