Dear Gurus,
We have a QlikSense Application and I want to add a new field related to "Date". Each record have a format like this:
dd:mm:aaaa hh:mm:ss
For example:
Creation Date:
18/04/2018 12:01:15
18/04/2018 18:14:54
19/04/2018 10:02:33
19/04/2018 11:45:15
19/04/2018 12:24:05
20/04/2018 09:54:34
20/04/2018 13:52:54
20/04/2018 19:43:05
I'm loading this field in the script like:
Date (Creation Date)
The problem is that after loading the data, it returns the following values:
18/04/2018
18/04/2018
18/04/2018
19/04/2018
19/04/2018
19/04/2018
20/04/2018
20/04/2018
20/04/2018
And I want to group the repeated values. So, I'd have to get:
18/04/2018
19/04/2018
20/04/2018
Any idea of how to handle it?
Thanks!!
