Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])),'#,###')
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])