Set Analyst With AutoCalande.Date = {'12-06-2023'}

[eddykwan_]

Hello I Want to ask How to make Set Analyst With AutoCalander.date with This data ? 

In Qliksense I Already make Setanalyst like This 

This my data i use date is = '2023-06-12' 

in my date filter is 6/12/2023 but i try used it is still zero and i try with combination date like '2023/06/12' And = '2023-Jun-12' But the data is still Zero in my KPi 

Please Help me to resolved it.

Thank You

[vinieme12]

this could be because the field is only FORMATTED as Date but the values are still stored as Timestamp

create a Datefield  as below and use AutoCalendar on the new field

Date(Floor(ProductTime)) as ProductDate

also you are missing {} in set analysis

sum( {<  ProductDate = {'$(=Date(Max(ProductDate)))'} >} SomeValue)