Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gautik92
Specialist III
Specialist III

Limit dates in Oracle

I have a table in oracle db where the data is till 4th june 2018 but i want to load data till previous month last date so am using this condition in select

Where to_number(to_char(SURVEY_DATE,'ddmmyyyyhh24miss'))<'$(vMaxDate)'

vMaxDate is having 01062018000000

this is not working.

Any other idea?

2 Replies
big_dreams
Creator III
Creator III

Can you post your script?

did you try hard coding value instead of variable

like

Where to_number(to_char(SURVEY_DATE,'ddmmyyyyhh24miss')) < 01062018000000


then check value of variable in text object.


Regards,

balabhaskarqlik

May be this,

Where to_number(to_char(SURVEY_DATE,'ddmmyyyyhh24miss')) <

to_number('$(vMaxDate)','ddmmyyyyhh24miss')

Or check the vMaxDate variable.