This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have a Problem in my DB. When i load the data from 2014. in some places, because of the user error. there some dates like 2090,2030 etc and also months.
How to filter data while loading from 2014 jan 1st to Todays date.
This is the filter which i used while loading the data to get data from 2014 jan1st.
FROM cmsdhcc.dbo."department_income_view" where YEAR("d_date") >=2014;
You can add where filter in your SQL statement smth like below:
where YEAR("d_date") >=2014 and "d_date"<=GETDATE(); - example for SQL server
You can filter out in your LOAD satement:
SQL SELECT ...
Hope this helps you.
View solution in original post
Use and trunc(d_date)<=trunc(sysdate())
FROM cmsdhcc.dbo."department_income_view" where YEAR("d_date") >=2014 and trunc(d_date)<=trunc(sysdate());