Conditional Count

[#1]

Hi-

I'm trying to only count records where the distance between the appointment scheduling date and the appointment date = 0. Essentially, I want to identify same day appointments. I've tried several variations of Count functions but can't seem to get it to select th

[sunny_talwar]

May be something like this:

Count({<[Appointment No.] = {"=Floor([Scheduling Date]) = Floor([Appointment Date])"}>} [Appointment No.])

[maxgro]

If the 2 fields are in the same table, you can add a field (a flag, 1 for same date) in the script and use the new field in the count

count({$ <NewField={1}>} AppointNo)

[#4]

That worked, thank you!

[HirisH_V7]

Hi,

Check this,

If([Scheduling Date]=[Appointment Date],Count(AppointmentNo))

Hope this Helps,

PFA,

Hirish

[sunny_talwar]

Awesome, I am glad I was able to help. Would you mind closing this thread down by marking correct answer and any other helpful answers (Qlik Community Tip: Marking Replies as Correct or Helpful)

Thanks and regards,

Sunny