Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
You could use exists or match Function to get the behaviour like "IN" of SQL in Qlik
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?
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
- Marcus
I solved it now. This worked:
if((inday(DateField,(today()-1),0)),1,0) as Yesterday
Thanks for your help anyway, guys!