Duplicate values appearing in Listbox

[guruprem]

Hi,

I loaded data from a logfile.txt  when I used LogDate as list box it started displaying duplicate values, please help as I this is not how Qlik normally displays list boxes

[Anonymous]

On the Number tab of the list box:

• Tick Override Document Settings
• Select Timestamp

Thus you should be able to whether these are indeed duplicates of discrete data or different Timestamps displayed merely as dates.

[sunny_talwar · Accepted solution]

To fix this, may be try this in the script:

Load Date(Floor(LogDate)) as LogDate

[guruprem]

Date is extracting fine with your suggestion. One follow up question is suggest way to get Hour from Timestamp?

[sunny_talwar]

May be this:

Load Date(Floor(LogDate)) as LogDate_Date

         Time(Frac(LogDate), 'hh:mm:ss') as LogDate_Time

[guruprem]

It is working. Thanks for help

[sunny_talwar]

No problem

I am glad I was able to help.

Best,

Sunny