Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Not applicable

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
Highlighted
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');

Highlighted
Not applicable

Thanks, but I am getting below error

Ss.PNG

Highlighted
Not applicable

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