Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
Yes! and as I mentioned it was working before.
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??
Same result. The data type is DateTime.
can you post a snapshot of your field [ItemExpiryDate]