Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ridleyyeh
New 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
MVP
MVP

Re: WHERE clause between SQL and QLIK SENSE

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

2 Replies
MVP
MVP

Re: WHERE clause between SQL and QLIK SENSE

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

ridleyyeh
New Contributor II

Re: WHERE clause between SQL and QLIK SENSE

thanks!! it works!!