CODEWITHSUNDEEP
qlikviewqliksenseqlik-expression
Matt
Matt

Reputation: 15071

Date function on Field not working on a count

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

Upvotes: 0

Views: 402

Answers (2)

Matt
Matt

Reputation: 15071

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)

Upvotes: 1

The Budac
The Budac

Reputation: 1633

You need to match the date format of the test string to the original.

=Count({<STARTTIMEDATE={"$(=Date(Today(),'YYYY-MM-DD HH:MM:SS:XXXXXX'))"}>} IDID)

In my mind I read STARTTIMEDATE as only a label / pointer for WHERE the set analysis should look rather than as a function to be evaluated

Upvotes: 1

Related Questions