3 Replies Latest reply: May 4, 2017 1:05 PM by Martin Hamilton RSS

    Duplicate values in filter pane - qlik sense

    Martin Hamilton

      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?


      any ideas?


      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.


      Thank You