Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Timstamp calculation issue 2

Hi guys,

please I have this timestamp format in my database timestamp= 2016-11-01 00:00:00.0000000 +00:00 and I convert it to this format Date = 2016-11-01  by using this expression in my script:    Date#(SubField(timestamp, ' ', 1),'YYYY-MM-DD')

I want whenever I choose a date for example 2016-11-01, I want to get the value of the th field quantity_value of this timestamp 2016-11-01 05:59:57.1810000 +00:00, and if I choose 2016-11-02 i want to get the value of this timestamp 2016-11-02 05:59:57.1810000 +00:00 and  so go on.

Please help me.

0 Replies