Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Fanch
Partner - Creator
Partner - Creator

Variable Date on URL API Rest Connection

Hi everybody,

i'm building a Qlickview document with API Rest Connection. On the URL, i need to have two variables begindata et enddata to have the data. I initialized the variable like this 🙂 :

// Variables bornes(ms) dans lien vrops

Let bornevrops=Date('01/01/1970 00:00:01');
Let bornebegin=Date('15/10/2020 00:00:01');
Let borneend=Date(Now(),'DD/MM/YYYY');
Let bornevropsms=Num(Date('01/01/1970 00:00:01')) * 86400000;
Let bornebeginms=Num(Date('15/10/2020 00:00:01')) * 86400000;
Let borneendms=Num(Date(Now()))* 86400000;
Let begindata=Num($(bornebeginms) - $(bornevropsms));
Let enddata=Num($(borneendms) - $(bornevropsms));

I continued to initialize the URL like this 🙂 :

$(begindata)&end%2$(enddata)&intervalType%2DAYS

At the date of 9th, december, it was ok. 😀

But today, when i reload the Qlikview document, my data stop at the 9th, december, ☹️

Vrops.JPG

Does anyone have an idea ???? 🙄

 

 

1 Solution

Accepted Solutions
Anil_Babu_Samineni

Since you are saying 8th  december it is working could be souce having issue with the format of 9th Dec - Check once?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

2 Replies
Anil_Babu_Samineni

Since you are saying 8th  december it is working could be souce having issue with the format of 9th Dec - Check once?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Fanch
Partner - Creator
Partner - Creator
Author

Thanks for our answer Anil 😉

But, it's just ..... a programming default that i resolved myself 🙄 🙄 🙄

Sorry for the inconvenience