Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld starts MONDAY! last chance to register is now ! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Fanch
Partner
Partner

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?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

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?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

Fanch
Partner
Partner
Author

Thanks for our answer Anil 😉

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

Sorry for the inconvenience