Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QV variable with timestamp as default value

Hi,

I have a variable assigned to an inputbox, and in that the default value is timestamp(today(), 'YYYY-MM-DD HH:MM:SS'). when i try to pass this variable in my sql's where clause as a parameter it give me different sorts of errors and doesnt like it. 

like: a non-numeric character was found where a numeric was expected

Can you please help me out here as to how do i pass the right values.

Database is an Oracle R12.

Thanks

1 Solution

Accepted Solutions
Not applicable
Author

Hi All,

I was able to resolve the issue by assigning the value to the variable in the script rather than in the input box.

Thanks all.

View solution in original post

3 Replies
maxgro
MVP
MVP

if your Qlik variable is vVar ( with this format YYYY-MM-DD HH:MM:SS)

in Oracle you can filter in this way (replace DATE with your Oracle field)

WHERE DATE > to_date('$(vVar)', 'YYYY-MM-DD HH:MI:SS');

Not applicable
Author

Thanks, but I am getting below error

Ss.PNG

Not applicable
Author

Hi All,

I was able to resolve the issue by assigning the value to the variable in the script rather than in the input box.

Thanks all.

View solution in original post