This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have been trying remove the duplicate login times(6:30 and 15:30)
How do we remove these duplicates??
PFA, for your reference!!!
Load your data like this
LOAD Time(Round([login time], 1/1440)) as [login time]
(ooxml, embedded labels, table is Sheet1);
View solution in original post
May be this?
Aggr([login time], [login time])
Thank you sunny !!!
I wanted to know whats wrong with the existing format????
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
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
LOAD Time(Round([login time], 1/86400)) as [login time]