Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
morenoju
Partner - Specialist
Partner - Specialist

ValueLoop to Timestamp

Hi all,

I need a list of timestamps between two timestamps with a 15 minute interval.

I'm using this dimension:

=ValueLoop(start_timestamp,close_timestamp,15/(24*60))

It's working, but the result I get are the decimal representation of the timestamps (e.g. 43651.40625). I tried to do:

=Timestamp(ValueLoop(start_timestamp,close_timestamp,15/(24*60)))

But that gives me an "Internal Engine Error". Any idea on how to convert the result to timestamps? Thanks!

Juan

Labels (2)
1 Reply
Yoshidaqlik
Creator II
Creator II

Hi

In this case to format in the dimension I think I would have to create an additional table in the script.

I believe ValueLoop can only be formatted as a measure

you can set a counter and format the measurement as an optional solution

dimension

=ValueLoop(start_timestamp,(close_timestamp-start_timestamp)/(15/(24*60))+1)

 

measure

=Timestamp(ValueLoop(start_timestamp,(close_timestamp-start_timestamp)/(15/(24*60))+1) * (15/(24*60)) + start_timestamp)

 

Capture.PNG

 

Regards

YoshidaQlik https://www.youtube.com/channel/UC1I9P8MqCZEhB6Nw3FdSqng