Discussion board where members can get started with Qlik Sense.
within a filter pane duplicate values are being displayed.
I am converting a date format of the following:
using the following load script:
Date(Timestamp#(DATE_CREATED,'DD-MMM-YY hh.mm.ss.fffffffff'),'DD/MM/YYYY') as DateField
It looks like some hidden values are being included hence its not distinct within the column?
i have tried differing options such as Floor but doesnt seem to work. I also thought about splitting the field but that becomes messy by the look of it.
Go to Solution.
Try the following:
Date(Floor(Timestamp#(DATE_CREATED,'DD-MMM-YY hh.mm.ss.fffffffff')),'DD/MM/YYYY') as DateField
I hope it works.
You said you used floor and it didn't work. Another possible option would be:
Makedate(Year(DateField1).Month(DateField1),day(DateField1)) AS DateField;
Date(Timestamp#(DATE_CREATED,'DD-MMM-YY hh.mm.ss.fffffffff'),'DD/MM/YYYY') as DateField1
Resident .... ;
Drop Field DateField1;
Try to convert the calculated date into text.
Thanks in the end I used the following:
Date(Floor(DATE_CREATED), 'DD/MM/YYYY') as [Session Date]
I must have made a mistake previously.