Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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



17 Replies
Not applicable
Author

I am sorry but could you please show me where to place the two lines...
I have attached the script

Many thank in advance

Not applicable
Author

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?

Gysbert_Wassenaar

Add the two lines to the load that loads the data from your source table. The table you named Orders. In the AppsPackBAU section.


talk is cheap, supply exceeds demand
Not applicable
Author

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

Gysbert_Wassenaar

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)


talk is cheap, supply exceeds demand
Not applicable
Author

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)

Gysbert_Wassenaar

No idea. I can't mind read your app from here.


talk is cheap, supply exceeds demand
Not applicable
Author

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"