Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Qqqqqq
Contributor
Contributor

Timestamp format syntax in Qliksense data load editor?

I would like to add a where clause to filter on a date variable in the Qliksense data load editor. However this results in an for the error. Can you please confirm the correct syntax? Is another function required?

 For Redshift SQL code: where date >= Timestamp "2021-03-01 00:00:00"

Example

Load

a,b,c,date

SQL

Select a,b,c,date

from table

where year(date) >=2021

 

Labels (1)
1 Reply
rubenmarin

Hi, if the 'For Redshift SQL code' is the correct syntax you can use that syntax in the load editor:

Load
a,b,c,date
SQL
Select a,b,c,date
from table
where date >= Timestamp "2021-01-01 00:00:00";

In summary: the 'Load' part uses qlik syntax, the 'SQL' part uses datasource syntax.

You can use $() to insert dynamic values on SQL part like:

LET vThisYear = Year(Today());
Table:
Load
a,b,c,date
SQL
Select a,b,c,date
from table
where date >= Timestamp "$(vThisYear)-01-01 00:00:00";