Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

= and <> in QV

Hi

I am trying to load the data from the SQL Server using where clause as per the below

LOAD EmployeeID,

    LastName,

    FirstName,

    Title,

SQL SELECT *

FROM Northwind.dbo.Employees

WHERE Country ='UK';

Can anyone please suggest ho to use <>(not equal to) condition with where clause for example if i need to load as per the below statement

LOAD EmployeeID,

    LastName,

    FirstName,

    Title,

SQL SELECT *

FROM Northwind.dbo.Employees

WHERE Country <>'UK';

Thanking You

Vinayagam

10 Replies
Not applicable
Author

ohh sory sir ....done the same will try to follow the practice