How to display single column date field in qliksense

[rajneesh]

Hi Team,

In below filter it is showing multiple same dates. I want display the only single date in the chart.6/8/2022 is repeated 4 times but want show single.

Thanks

Rajneesh

[PrashantSangle]

in your script, use date(floor(datefield)) as datefield.

Regards,

Prashant Sangle

[MarcoWedel]

your dates are in fact timestamps that just have been formatted to not show the time part.

You could load the date field e.g. like:

LOAD DayName(date) as date
FROM ...