Counting only today's date

jlampard40 — Wed, 22 Dec 2021 16:36:32 GMT

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])),'#,###')

Re: Counting only today's date

sunny_talwar — Tue, 01 Oct 2019 11:59:08 GMT

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

topic Counting only today's date in App Development

Counting only today's date

Re: Counting only today's date