Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
antonybi
Creator
Creator

remove

Hi,

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

How do we remove these duplicates??

123.PNG

urgent,kindly suggest.

PFA, for your reference!!!

1 Solution

Accepted Solutions
sunny_talwar

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);

View solution in original post

4 Replies
Anil_Babu_Samineni

May be this?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sunny_talwar

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);

antonybi
Creator
Creator
Author

Thank you sunny !!!

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

sunny_talwar

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);