Qlik Community

Ask a Question

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

in

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

1 Solution

Accepted Solutions
Contributor III
Contributor III

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
Specialist II
Specialist II

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

Contributor III
Contributor III

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?

Specialist II
Specialist II

Could you share a sample 

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.

MVP & Luminary
MVP & Luminary

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

Contributor III
Contributor III

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