Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rafaeloneil
New Contributor III

Calculation Between Two Dates Expression

Staff, Good evening,

I have a table:

Table.png

I'm riding a PivotTable that need to have a field that Count how many contracts meet the following criteries:

  • ((CodStatusBx = 0))
  • Diference apart from days (Current Date - Date Contract) greater than 10 calendar days


This expression is not working for me
Count({$<CodStatusBx={0}>} fabs(Date(Today(),'DD/MM/YYYY')) - fabs(Date(DtContrato,'DD/MM/YYYY')))


Could help me?


1 Solution

Accepted Solutions

Re: Calculation Between Two Dates Expression

May be this:

Count({$<CodStatusBx={0}, DtContrato = {"$(='>=' & Date(Today() - 10, 'DD/MM/YYYY'))"}>} NuContrato)

2 Replies

Re: Calculation Between Two Dates Expression

May be this:

Count({$<CodStatusBx={0}, DtContrato = {"$(='>=' & Date(Today() - 10, 'DD/MM/YYYY'))"}>} NuContrato)

rafaeloneil
New Contributor III

Re: Calculation Between Two Dates Expression

Thanks for the tip at the end, I had to create the calculation in Table before loading the data to get the correct result, Thank you Sunny!