Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Reload

Sorry for my bad english...

can i put on the reload script of the QVW file; the report ,

put in the sql select the following expresion before the table: WITH (NOLOCK) .

for example

SQL select * from employees WITH (NOLOCK) where bithday=today();

thanks..

Labels (1)
1 Solution

Accepted Solutions
Not applicable
Author

Yes, you can use with(Nolock) in your SQL if you are using SQL Server. But I think you need to use "getdate()" function for today.

/Michael

View solution in original post

1 Reply
Not applicable
Author

Yes, you can use with(Nolock) in your SQL if you are using SQL Server. But I think you need to use "getdate()" function for today.

/Michael