KPI Expression Doesn't Work Anymore?

[Anonymous]

Hello Everyone!

So we have been working with Qlik Sense for a while now, and when we started to used to have the following expression in a KPI chart:

Count({<[ItemExpiryDate] = {"$(='<' & Date(Today()))"}>} distinct ItemID)

When we did a reload last week the value of the KPI chart is always equal to ZERO. We have checked the data and everything seems fine; however, I'd like to figure out why is Qlik Sense giving us this result. .

Your help is really appreciated,

[Anonymous]

Yes! and as I mentioned it was working before.

[vinieme12]

removing the equal sign here

Count({<[ItemExpiryDate] = {"<=$(Date(Today(),'M/D/YYYY'))"}>} distinct ItemID)

or could it be that your [ItemExpiryDate] is coming in as VarChar instead of Date??

[Anonymous]

Same result. The data type is DateTime.

[vinieme12]

can you post a snapshot of your field [ItemExpiryDate]