Emmanuel Katto Dubai : How to Count Today's Occurrences Using Set Analysis in QlikView/Qlik Sense?

[emmanuelkatto24]

Hi all,

I’m Emmanuel Katto from Dubai, United Arab Emirates (UAE) trying to count the occurrences of a field (MyField) based on today’s date, but I’m running into some issues when working with the CompletionDate field, which is a timestamp.

Here’s what I’ve tried so far:

1. This formula throws an error:

Count({<Date(CompletionDate, 'DD/MM/YYYY')={$("=Date(Today(), 'DD/MM/YYYY')")} MyField)

This one returns zero:

javascript

Count({<CompletionDate={$("=Date(Today(), 'DD/MM/YYYY')")} MyField)

The CompletionDate field is a timestamp, and I need to count occurrences of MyField where the date part matches today’s date.

Has anyone faced this issue or know how I can get the correct count for today’s occurrences? Any suggestions or alternative approaches would be greatly appreciated!

Thanks!

Regards

Emmanuel Katto

[VBD]

Hello, 

The best is to create an other field in your script with the "floor()" function.

Floor(CompletionDate) as "mydate"

Or you can use a set analysis when your date is between today-1 and today+1

Count({<CompletionDate={>$("=Date(Today()-1, 'DD/MM/YYYY')")<$("=Date(Today()+1, 'DD/MM/YYYY')")} MyField)

regards,

[Qrishna]

Hows yu date look like. could you provide some sample data for both MyField and CompletionDate ?

[VBD]

Hello, 

Could you do a feedback please ?

Regards,