unique dates

[qvqfqlik]

Please help with showing distinct dates in the search for table columns in qliksense

I tried distinct(datefield) but this didnot help.

[swuehl · Accepted solution]

Your date values are probably timestamps.

When loading in your date values, truncate the time part:

LOAD

     Date(Floor( DATEFIELD),'DD/MMM/YYYY') as Date,

[qvqfqlik]

Thanks very much Stefan! Your right! that worked