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: 
materi
Contributor III
Contributor III

in

How do you manage the SQL "in" function in Clik Sense scripts?

Labels (1)
1 Solution

Accepted Solutions
materi
Contributor III
Contributor III
Author

I solved it now. This worked:

if((inday(DateField,(today()-1),0)),1,0) as Yesterday

Thanks for your help anyway, guys!

View solution in original post

6 Replies
anushree1
Specialist II
Specialist II

You could use exists or match Function to get the behaviour like "IN" of SQL in Qlik

materi
Contributor III
Contributor III
Author

Thanks Anushree1!

I'm trying to use wildmatch because I only want to search for the date in a field with timestamp data, so I wrote the following expression:

if(wildmatch(TimeStamp(TimeStampField),(today()-1)),1,0) as Yesterday

which didn't give any hits. Any hints on what would work here?

anushree1
Specialist II
Specialist II

Could you share a sample 

tresesco
MVP
MVP

It seems that your expression is an overkill. Could you explain exactly what you are looking for? Expression probably would be a simpler one.

marcus_sommer

If you want to check for a numeric value you should also apply a numeric comparing and not on a string-level. Therefore try the following:

-(floor(TimeStampField) = today()-1) as Yesterday

- Marcus

materi
Contributor III
Contributor III
Author

I solved it now. This worked:

if((inday(DateField,(today()-1),0)),1,0) as Yesterday

Thanks for your help anyway, guys!