Discussion board where members can get started with Qlik Sense.
Hi guys, stalwar1
If I want to search for every field that contains the A letter I would do :
where field like '*A*'
Now what if I wanted to search for everyfield containing today() ?
How to that since :
where field like '*Today()*' does not work ; syntax error.
Go to Solution.
If you want to replace Today() with today's date, you need to use dollar sign expansion:
Let vDate = Today(); // potential need to format using Date() to match your field values
WHERE FIELD LIKE '*$(vDate)*';
Or maybe just this?
WHERE FIELD = Today();
is today() is value?
Can you post a screenshot of the error message?
When I created a variable :
let vToday= today()
and then in my condition I used this variable :
where field like '*$(vToday)*' it worked.
That won't work unless It's stored in a variable then we call the variable.
When I did that, It worked just fine
Yes, well seen ! I just did that and I worked like a charm !