Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please help with showing distinct dates in the search for table columns in qliksense
I tried distinct(datefield) but this didnot help.
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,
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,
Thanks very much Stefan! Your right! that worked