Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this:
Let vNow=floor(Now(),1/24/60);
Load
TimeStamp($(vNow)+2*RowNo()/24/60) as t_Stamp
AutoGenerate 24*60+1;
This is not working for me. I just get a table with one value inside.
Can you please post a fully functioning example.
PFA, just copy-pasted the script; ran reload..