Fetching data from SQL

Ayoub — Wed, 24 Apr 2019 09:29:24 GMT

Hello Community,

I have a little problem here.

I Have two table Referentiel(Code,Type,DateImg) and Client(Code,Name,CIN) .

i want to get all those information which DateIMG = date(now()-1,'DDMMYYYY');

The problem resident in clause Where, it's limited in 1000 rows.

How Can I fetch more than 1000 rows in a time.

Thank you for your Help

Re: Fetching data from SQL

Claudiu_Anghelescu — Thu, 25 Apr 2019 08:27:45 GMT

You can get all the data from SQL in a temporary table in Qlik and then you can get the filtered data from the temporary table.

Or you can use the condition DateIMG = date(now()-1,'DDMMYYYY') wrriten in SQL code but not Qlik code.

topic Re: Fetching data from SQL in QlikView

Fetching data from SQL

Re: Fetching data from SQL