topic Re: QV variable with timestamp as default value in QlikView

QV variable with timestamp as default value

Wed, 15 Jul 2015 16:54:53 GMT

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

Re: QV variable with timestamp as default value

maxgro — Wed, 15 Jul 2015 17:19:29 GMT

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

Re: QV variable with timestamp as default value

Thu, 16 Jul 2015 08:15:08 GMT

Thanks, but I am getting below error

Re: QV variable with timestamp as default value

Thu, 16 Jul 2015 08:30:25 GMT

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.