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: 
ridleyyeh
Contributor II
Contributor II

WHERE clause between SQL and QLIK SENSE

I've watching some videos which teaching qliksense users how to use where clause on qliksense  .

and when im trying to use where clause and choose which column could be one of my conditions, it turn out to be the red words as the pic down below....Can anyone figure it out what happened..?

The original SQL query that i wanna use in qliksense is "select * from PatientInfo where CallTime IS NOT NULL and VerifyTime is not null and RegisterDate IS NOT NULL and CompleteDate IS NOT NULL and Name IS NOT NULL"

 

Thanks in advanced
red lines.JPG

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Remove semi-colon ';' before where clause and try again.

View solution in original post

2 Replies
tresesco
MVP
MVP

Remove semi-colon ';' before where clause and try again.

ridleyyeh
Contributor II
Contributor II
Author

thanks!! it works!!