topic Re: Duplicate values appearing in Listbox in QlikView

Duplicate values appearing in Listbox

guruprem — Wed, 15 Jul 2015 16:35:49 GMT

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

Re: Duplicate values appearing in Listbox

Anonymous — Wed, 15 Jul 2015 16:39:34 GMT

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.

Re: Duplicate values appearing in Listbox

sunny_talwar — Wed, 15 Jul 2015 16:41:57 GMT

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

Load Date(Floor(LogDate)) as LogDate

Re: Duplicate values appearing in Listbox

guruprem — Wed, 15 Jul 2015 16:46:55 GMT

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

Re: Duplicate values appearing in Listbox

sunny_talwar — Wed, 15 Jul 2015 16:50:30 GMT

May be this:

Load Date(Floor(LogDate)) as LogDate_Date

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

Re: Duplicate values appearing in Listbox

guruprem — Wed, 15 Jul 2015 16:53:05 GMT

It is working. Thanks for help

Re: Duplicate values appearing in Listbox

sunny_talwar — Wed, 15 Jul 2015 16:53:57 GMT

No problem

I am glad I was able to help.

Best,

Sunny