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:

       

      18-APR-17 14.13.11.039000000

       

      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

       

      Martin