Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Help with hour 00:00 / 24:00

Hi,

I need some help with the clock in my application..

The problem is that hour 00:00 is sorted before hour 01:00 and not after 23:00..

value 5 in 01.04-00:00 supposed to be placed right in my table. After 01.04-23:00. How can i fix this?

4 Replies
Sergey_Shuklin
Specialist
Specialist

Hello, Marius!

You can catch a midnight with Text() function:

=if(right(Text(time),8)='00:00:00',max(RowNo()),RowNo())

(This expression I used as sort expression.)

PFA.

vinieme12
Champion III
Champion III

but why?

what is 01:00 counting here? data from 00:00 to  01:00 or 01:00 to 02:00?

if 00:00 is 24:00, then just replace them with and IF() during load !!

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Anonymous
Not applicable
Author

Thanks, but it did not work.. now it shows 01.04 00:00, 02.04 00:00, 03.04:00 .....

any other suggestions?

/Marius

Anonymous
Not applicable
Author

thanks for reply.

01:00 is 01:00 - 02:00

00:00 is 00:00/24:00 - 01:00

"if 00:00 is 24:00, then just replace them with and IF() during load !!"

got an example for that?