Counting only today's date

[jlampard40]

Hi guys

I have some reports I'm concatenating within my script, to be able to produce a historical look at the data as well as the snapshot data of today (current date).  The report is run daily so I want to be able to show the current number of clients who are waiting as of today (current date).  I have a field I've added into my reports called [WBR_Stat_Date] - this simply contains the date the report is run.  

To be able to show just today's report, I need to somehow tell Qlikview to just read the data belonging to WBR_Stat_Date of today.  It needs to be represented as a number in a text box, but not getting any joy with my set analysis below.  Can you help?  Many thanks.

=num(count(DISTINCT(<{[WBR_Stat_Date]=today()>}, [WBR_Event_Key])),'#,###')

[sunny_talwar]

Try like this (just like you have it in your other post)

=Count({$<[WBR_Stat_Date]={"$(=Date(Today(),'DD/MM/YYYY'))"}>} DISTINCT [WBR_Event_Key])

Median for today's date only