This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board where members can learn more about Qlik Sense App Development and Usage.
How do you manage the SQL "in" function in Clik Sense scripts?
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
You could use exists or match Function to get the behaviour like "IN" of SQL in Qlik
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?
Could you share a sample
It seems that your expression is an overkill. Could you explain exactly what you are looking for? Expression probably would be a simpler one.
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