Date Filter in Set Analysis

[#1]

HI

Using Qlik Sense

I have an expression

COUNT ({<[Current Status] = {"Awaiting"}>}[Claim Ref]) And [Current Status Date] = Date(Today(-14))

So what I need the expression to do is locate a claim where the status is Awaiting and the date in the Current status date column is from 14 days ago or older.

Any help would be much appreciated

Thanks in advance 

[Gysbert_Wassenaar]

Try: COUNT ({<[Current Status] = {"Awaiting"}, [Current Status Date] = {'<=$(=Today()-14)'}>}[Claim Ref])

[#3]

Hi

Unfortunately this does not return any data it displays the number as 0 but I know there are at least 100 Claims that fit the criteria.

I also tried to use an IF statement for this but with no luck

Thanks 

[Gysbert_Wassenaar]

Post a qlikview document that demonstrates the problem.

[#5]

I don't have a document I can show due to data protection. If it makes any difference all the data is pulled from a Spreadsheet in to Qlik Sense.

Could an expression like

Sum(Aggr(If([Current Status Date]) > Date(Today()-14),1,0)) [Current Status] = {"Awaiting})

Or something similar I'm pretty new to Qlik and not great at the syntax

[#6]

Status	Current Status Date	Status Month
Awaiting	23/8/15	8/15
Awaiting	28/8/15	8/15
Awaiting	11/5/15	5/15
Ended	5/915	9/15
Ended	8/10/14	10/14
Ended	6/9/13	9/13
Ended	23/12/14	12/14
Pending	11/9/15	9/15

Hi this is an example of what I have to work with so what I want is

If Status = "Awaiting" and Date is today()-14 or older then Count it. 

[Gysbert_Wassenaar]

The expression I posted should work if your field [Current Status Date] actually contains date values and not string values that only look like dates. If that field contains string values then you need to use the date# function in the script to turn those strings into dates:

LOAD

     ...some fields...,

     date#([Current Status Date],'D/M/YY') as [Current Status Date],

     ...some more fields...

FROM ...

[#8 · Accepted solution]

I have Solved this Now I used some logic from what you posted Gysbert Wassenaar and some from other sources the expression is now:

Count ({<[Status] = {" Awaiting"}>}If ([Current Status Date] < Date(Today()-26),0)) 

this shows everything that is 26 days and older

Cheers