topic Re: Conditional Count in QlikView

Conditional Count

Sun, 14 Feb 2016 16:23:06 GMT

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

Re: Conditional Count

sunny_talwar — Sun, 14 Feb 2016 17:04:05 GMT

May be something like this:

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

Re: Conditional Count

maxgro — Sun, 14 Feb 2016 18:14:18 GMT

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)

Re: Conditional Count

Mon, 15 Feb 2016 01:55:54 GMT

That worked, thank you!

Re: Conditional Count

HirisH_V7 — Mon, 15 Feb 2016 04:34:39 GMT

Hi,

Check this,

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

Hope this Helps,

PFA,

Hirish

Re: Conditional Count

sunny_talwar — Mon, 15 Feb 2016 13:49:17 GMT

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