Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Master calendar should start exactly 2 days from now (rounded on minutes)

Hi guys,

Potentially I missed the right post, which solves this problem, but I didn't figure out yet, of how to create a master calendar in Qlick Sense, which starts exactly 2 days from now (rounded on minutes) and has one row each minute.

So what I want is a calendar like this (Now it is 2017/10/25 10:53:22):

t_stamp

2017/10/23 10:53:00

2017/10/23 10:54:00

2017/10/23 10:55:00

.

.

.

2017/10/25 10:53:00

The problem is, that the script I found which generates the master calendar always rounds the timestamp to a date. But in my case, the past data horizon should always be 2 days, not varying dependent on the actual date.

3 Replies
tresesco
MVP
MVP

Try this:

Let vNow=floor(Now(),1/24/60);

Load

       TimeStamp($(vNow)+2*RowNo()/24/60) as t_Stamp

  

AutoGenerate 24*60+1;

Anonymous
Not applicable
Author

This is not working for me. I just get a table with one value inside.

Can you please post a fully functioning example.

tresesco
MVP
MVP

PFA, just copy-pasted the script; ran reload..

Capture.JPG