Discussion board where members can get started with QlikView.
I have a MySQL DB from which i am fetching the data into QlikView
and the there is a date field whise data type is datetime '2020-05-06 03:14:43'
in qlikview i have converted the this format to Date(Date,'YYYY-MM-DD') whihc is correct and also took the last update date
Date(Max(Date),'YYYY-MM-DD') and store in a variable .
now when i want to fetch the data greater than the last updated in qlikview this is not working the data from the MySQL is fetching the all the data and the records are doubles .
100 records fetched and convetred into QVD format and i have created the vLastUpdated from max of date
and when i concatenate the fetch from DB the data is not considering the vLAst update and rather loadin the records as
200 rows .
Any sugestion on this ? do i need to convert date format for mysql
just try this
SQL select * from sales.db
Where loaddate > '2020-05-13 00:00:00';
View solution in original post
Anu suggestions in my post ?
I even tried to fetch the data by giving manual date but still the qlikview is fetching the whole data from MySQL db
SQL * select from sales.db
Where loaddate > date_format('2020-05-11','%Y-%m-%d');
But still the data is not laoding after 11th but it is laoding the complete data . I really don't understand this .
Your input will really help in resolving this issue .
Since I am typing from mobile there might be typo error please discard
have you tried this code in your mysql environment
Is it working over there???
I tred the query in Qlikview but it is fetching the whole data
but the same query work well and good in MySQL and gives me the data greater than the specified date .
I am really stuck on this ...
Thanks Prashanth this worked