topic MySQL QUERY in QlikView

MySQL QUERY

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

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 .

Example

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

Thanks

Re: MySQL QUERY

smilingjohn — Tue, 12 May 2020 19:41:22 GMT

Hi .

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

Load

Sales,

Loaddate

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

Thanks

Re: MySQL QUERY

PrashantSangle — Tue, 12 May 2020 20:57:38 GMT

have you tried this code in your mysql environment

SQL * select from sales.db

Where loaddate > date_format('2020-05-11','%Y-%m-%d');

Is it working over there???

Re: MySQL QUERY

PrashantSangle — Tue, 12 May 2020 20:59:35 GMT

just try this

SQL select * from sales.db

Where loaddate > '2020-05-13 00:00:00';

Re: MySQL QUERY

smilingjohn — Tue, 12 May 2020 21:54:25 GMT

Hi Prashanth,

I tred the query in Qlikview but it is fetching the whole data

SQL select * from sales.db

Where loaddate > '2020-05-13 00:00:00';

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

Re: MySQL QUERY

smilingjohn — Tue, 12 May 2020 22:21:05 GMT

Thanks Prashanth this worked