Discussion board where members can get started with Qlik Sense.
I defined a vLastUpdatedDate variable using LET statement in the load script as following:
Load Date(MAX("Date")) as MaxDate
Let vLastUpdatedDate= Date(Peek('MaxDate', 0, DB));
drop table RecentDate;
As you can notice the variable is getting the correct value (26/08/2018) in the variables section inside the app:
When I calling the variable in an object it gets the following value:
Go to Solution.
in KPI Object try to use
what is your date format setting in main section (SET DateFormat='DD.MM.YYYY';)? Try to use some agregation function as it is the only value it doesnt matter and KPI will maybe handel it better.
Tnx! It works (not only in KPI object...)!