Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
aviadbein
Contributor II
Contributor II

Date variable in load script

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:

QlikQ.JPG

When I calling the variable in an object it gets the following value:

QlikQ2.JPG

Why so?

1 Solution

Accepted Solutions
shraddha_g
Partner - Master III
Partner - Master III

in KPI Object try to use

=vLastUpdatedDate

View solution in original post

3 Replies
shraddha_g
Partner - Master III
Partner - Master III

in KPI Object try to use

=vLastUpdatedDate

DavidŠtorek
Creator III
Creator III

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.

aviadbein
Contributor II
Contributor II
Author

Tnx! It works (not only in KPI object...)!