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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
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