Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Ayoub
Contributor III
Contributor III

Fetching data from SQL

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

1 Reply
Claudiu_Anghelescu
Specialist
Specialist

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.
To help community find solutions, please don't forget to mark as correct.