topic Re: in in App Development

in

materi — Fri, 02 Apr 2021 08:07:03 GMT

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

anushree1 — Tue, 24 Sep 2019 06:25:02 GMT

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

materi — Tue, 24 Sep 2019 07:00:16 GMT

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 — Tue, 24 Sep 2019 07:21:37 GMT

Could you share a sample

tresB — Tue, 24 Sep 2019 07:33:27 GMT

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 — Tue, 24 Sep 2019 08:20:04 GMT

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 — Tue, 24 Sep 2019 08:44:49 GMT

I solved it now. This worked:

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

Thanks for your help anyway, guys!