KPI with two date parameters

[jsjavier]

Hi I am new in using Qlik sense. I am using the KPI chart and I want to have a condition in counting.

Condition:

I want to count all person that is registered between Yesterday 12AM and TODAY 12AM

1.NAME

2.Registration_Date

my initial formula for this KPI is the basic formula which is  COUNT(name)

[Kashyap_R]

Hi

Try this

Make sure that Required_Date  is in DateTime Format

Count({<Required_Date= {">=$(=Timestamp#(Text(Date((Today()-1)))&' '&'12:00:00 AM','DD/MM/YYY h:mm:ss tt'))<=$(==Timestamp#(Text(Date((Today()-1)))&' '&'12:00:00 AM','DD/MM/YYY h:mm:ss tt') )"}>} Value)

Hope it helps

Thanks