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: 
Syed17
Contributor III
Contributor III

Please help me convert this oracle query into qliksense script

Hello All,

trunc(sysdate) between fa.start_date  and nvl(fa.end_date ,trunc(sysdate) + 1)

 

please help me to convert this query into qliksense script and is there any easy way to sort this types query into qlik script.

 

Labels (3)
2 Replies
vinieme12
Champion III
Champion III

as below

 

floor(sysdate) > floor(fa.start_date) and floor(sysdate) < alt(floor(fa.end_date) ,floor(sysdate) + 1)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Syed17
Contributor III
Contributor III
Author

I need to Convert query into Qliksense script Language sir...