Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I defined a vLastUpdatedDate variable using LET statement in the load script as following:
RecentDate:
Load Date(MAX("Date")) as MaxDate
Resident DB;
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:
Why so?
in KPI Object try to use
=vLastUpdatedDate
Hi,
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...)!