topic Re: remove in QlikView

remove

antonybi — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have been trying remove the duplicate login times(6:30 and 15:30)

How do we remove these duplicates??

urgent,kindly suggest.

PFA, for your reference!!!

Re: remove

Anil_Babu_Samineni — Tue, 05 Dec 2017 12:38:45 GMT

May be this?

Aggr([login time], [login time])

Re: remove

sunny_talwar — Tue, 05 Dec 2017 12:39:09 GMT

Load your data like this

temp:

LOAD Time(Round([login time], 1/1440)) as [login time]

FROM

demo.xlsx

(ooxml, embedded labels, table is Sheet1);

Re: remove

antonybi — Tue, 05 Dec 2017 12:52:23 GMT

Thank you sunny !!!

I wanted to know whats wrong with the existing format????

Re: remove

sunny_talwar — Tue, 05 Dec 2017 13:00:06 GMT

Not entirely sure, but it seems that this was related to decimal numbers not entirely matching between the two 6:30 pm... they might look something like this

0.27083333333333333

0.27083333333333334

In order to make the two number equal, we rounded them to the nearest minute... you can round them to nearest second, if you have seconds by using this

temp:

LOAD Time(Round([login time], 1/86400)) as [login time]

FROM

demo.xlsx

(ooxml, embedded labels, table is Sheet1);