Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Count which is giving me the following error:
Error in set modifier expression
The Expression is:
=Count({<date(STARTTIMEDATE)={"$(=Date(Today()))"}>} IDID)
STARTTIMEDATE is in the format of YYYY-MM-DD HH:MM:SS:XXXXXX
May be this
=Count({<STARTTIMEDATE = {">=$(=TimeStamp(Today(), 'YYYY-MM-DD hh:mm:ss:fff))<=$(=TimeStamp(DayEnd(Today()), 'YYYY-MM-DD hh:mm:ss:fff))"}>} IDID)
or change the field to a date field in the script like this
Date(Floor(STARTTIMEDATE)) as STARTDATE
and then this
=Count({<STARTDATE = {"$(=Date(Today()))"}>} IDID)
=Count({<STARTTIMEDATE = {">=$(=TimeStamp(Today(), 'YYYY-MM-DD hh:mm:ss:fff))<=$(=TimeStamp(DayEnd(Today()), 'YYYY-MM-DD hh:mm:ss:fff))"}>} IDID)
Is returning the same as if i was just doing =COUNT(IDID)
Would you be able to post a screenshot of STARTTIMEDATE field in a filter box in your Qlik Sense dashboard?
Here are some examples of STARTTIMEDATE :
2018-01-02 06:11:19.617
2018-01-02 06:11:40.260
2018-01-02 06:12:17.260
2018-01-02 06:12:38.740
2018-01-02 06:12:52.403
That is what you see in Qlik Sense or the source?
Both,
I also created a new field that is just dd/mm/yyyy and tried =Count({<STARTDATE= {"$(=Date(Today()))"}>} IDID) but get no results
Can you share the script you used to create the new field?
I have resolved this by using this in my load script:
CONVERT(VARCHAR(10),CAST(STARTTIMEDATE as DATE),103) AS STARTDATE
Then this as my expression:
=Count({$<YEAR=,STARTDATE={"$(=Date(Today()-1))"}>} IDID)
Do you have a preceding load on top of your query? If you do, add this in there
LOAD Date(STARTDATE) as STARTDATE,
...,
SQL SELECT ...
see if that works for you