topic Re: extracting Data from Sql server in QlikView

extracting Data from Sql server

ebrahimaljafri — Mon, 10 Sep 2018 09:35:27 GMT

hi Qlikers,

i am extracting data from SQL server for certain period of date using SQL where clause column date >= '20180601' and column date<= '20180831' ; actually , i am only getting data for jun first only and then application save as there are no more data.

note i have check data in SQL server using SQL server manager using same SQl query used in qlik and there are data for all jun ,July and august.

has any one faced such an issue ??

Re: extracting Data from Sql server

atoz1158 — Mon, 10 Sep 2018 09:45:45 GMT

Try using

MyDate >= '2018/06/01' AND MyDate <= '2018/08/31'

Regards

Adrian

Re: extracting Data from Sql server

ebrahimaljafri — Mon, 10 Sep 2018 09:53:24 GMT

thank you atoz1158‌

in my scenario i do not think is the issue because of the date format . in fact . each column date record = '20180801000000' .

does windows server memory and hard disk space might cause such an issue ?